User Tools
niota-docs:niota_sample_values
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
niota-docs:niota_sample_values [2021/11/14 10:47] admin created |
niota-docs:niota_sample_values [2025/07/17 14:11] (current) |
||
|---|---|---|---|
| Line 2: | Line 2: | ||
| === database character set === | === database character set === | ||
| - | *''AL32UTF8'' - Oracle UTF8 | + | * ''AL32UTF8'' - Oracle UTF8 |
| - | *''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 | ||
| + | |||
| + | === 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 2 digits | ||
| + | * ''m'' - month, numeric (00-12) | ||
| + | * ''M'' - month name (January-December) | ||
| + | * ''d'' - day of month, numeric (00-31) | ||
| + | * ''H'' - hour (00-23) | ||
| + | * ''h'',''I'' - hour (01-12) | ||
| + | * ''i'' - minutes, numeric (00-59) | ||
| + | * ''s'',''S'' - seconds (00-59) | ||
| + | * ''p'' - am/pm | ||
| + | * ''r'' - time, 12-hour (hh:mm:ss) followed by AM or PM) | ||
| + | * ''T'' - time, 24 hour (hh:mm:ss) | ||
| + | * ''f'' - microseconds (000000-999999) | ||
| + | * ''b'' - month, numeric (00-12) only for Oracle connections | ||
| + | |||
| + | == display number decimal point recommended characters === | ||
| + | |||
| + | * '','' European | ||
| + | * ''.'' US | ||
| + | | ||
niota-docs/niota_sample_values.1636883271.txt.gz · Last modified: 2025/07/17 14:11 (external edit)