=== 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