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:03] 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. | ||
| - | * ''Y year, 4 digits | + | Sample value(s): |
| - | * ''y year 2 digits | + | <code> |
| - | * ''m'' month, numeric (00-12) | + | Y-m-d |
| - | * ''M'' month name (January-December) | + | </code> |
| - | * ''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 | + | |
| + | === 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.1636884194.txt.gz · Last modified: 2025/07/17 14:11 (external edit)