=== database character set ===
* ''AL32UTF8'' - Oracle UTF8
* ''iso-8859-2'' - Windows typical western character set
* ''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):
Y-m-d
=== source datetime format ===
Formatstring with separator character that describes how datetime variables are stored in the database.
Sample value(s):
Y-m-d H:i:s.f
=== display date format ===
Formatstring with separator character that describes how date variables are displayed in niota.
Sample value(s):
Y-m-d
=== display datetime format ===
Formatstring with separator character that describes how datetime variables displayed in niota.
Sample value(s):
Y-m-d H:i:s
== 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