User Tools
niota-docs:niota_sample_values
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
niota-docs:niota_sample_values [2021/11/14 11:04] admin |
niota-docs:niota_sample_values [2025/07/17 14:11] (current) |
||
|---|---|---|---|
| Line 5: | Line 5: | ||
| * ''iso-8859-2'' - Windows typical western character set | * ''iso-8859-2'' - Windows typical western character set | ||
| * ''UTF-8'' | * ''UTF-8'' | ||
| + | * ''SQLSRV_ENC_CHAR'' -- system variable in case of native MS SQL server connection when DB is not UTF-8 | ||
| - | Date and date-time format characters | + | === source date format === |
| + | Formatstring with separator character that describes how date variables are stored in the database. | ||
| + | |||
| + | Sample value(s): | ||
| + | <code> | ||
| + | Y-m-d | ||
| + | </code> | ||
| + | |||
| + | === source datetime format === | ||
| + | Formatstring with separator character that describes how datetime variables are stored in the database. | ||
| + | |||
| + | Sample value(s): | ||
| + | <code> | ||
| + | Y-m-d H:i:s.f | ||
| + | </code> | ||
| + | |||
| + | === display date format === | ||
| + | Formatstring with separator character that describes how date variables are displayed in niota. | ||
| + | |||
| + | Sample value(s): | ||
| + | <code> | ||
| + | Y-m-d | ||
| + | </code> | ||
| + | |||
| + | === display datetime format === | ||
| + | Formatstring with separator character that describes how datetime variables displayed in niota. | ||
| + | |||
| + | Sample value(s): | ||
| + | <code> | ||
| + | Y-m-d H:i:s | ||
| + | </code> | ||
| + | |||
| + | == date and datetime recommended separator characters === | ||
| + | |||
| + | * ''-'' date separator | ||
| + | * '':'' time separator | ||
| + | * ''.'' milisecond separator | ||
| + | |||
| + | === date and datetime format characters === | ||
| + | A date/datetime string must contain only valid format characters. All invalid format characters are treated as separators/strings. | ||
| * ''Y'' - year, 4 digits | * ''Y'' - year, 4 digits | ||
| Line 16: | Line 56: | ||
| * ''h'',''I'' - hour (01-12) | * ''h'',''I'' - hour (01-12) | ||
| * ''i'' - minutes, numeric (00-59) | * ''i'' - minutes, numeric (00-59) | ||
| - | * ''s'',''S''vseconds (00-59) | + | * ''s'',''S'' - seconds (00-59) |
| * ''p'' - am/pm | * ''p'' - am/pm | ||
| * ''r'' - time, 12-hour (hh:mm:ss) followed by AM or PM) | * ''r'' - time, 12-hour (hh:mm:ss) followed by AM or PM) | ||
| Line 23: | Line 63: | ||
| * ''b'' - month, numeric (00-12) only for Oracle connections | * ''b'' - month, numeric (00-12) only for Oracle connections | ||
| + | == display number decimal point recommended characters === | ||
| + | |||
| + | * '','' European | ||
| + | * ''.'' US | ||
| + | | ||
niota-docs/niota_sample_values.1636884272.txt.gz · Last modified: 2025/07/17 14:11 (external edit)