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:09] 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 | ||
| === source date format === | === source date format === | ||
| - | Formatstring with separator character that describes how date variables are stored in the database. String must contain only valid format characters. All invalid format characters are treated as separotors/strings. | + | Formatstring with separator character that describes how date variables are stored in the database. |
| - | Sample values: | + | Sample value(s): |
| <code> | <code> | ||
| Y-m-d | Y-m-d | ||
| Line 16: | Line 17: | ||
| === source datetime format === | === source datetime format === | ||
| Formatstring with separator character that describes how datetime variables are stored in the database. | 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 === | === display date format === | ||
| - | Formatstring with separator character that describes how date variables are stored in the database. | + | 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 === | === 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 38: | 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.1636884578.txt.gz · Last modified: 2025/07/17 14:11 (external edit)