niota

• 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

Formatstring with separator character that describes how date variables are stored in the database.

Sample value(s):

Y-m-d

Formatstring with separator character that describes how datetime variables are stored in the database.

Sample value(s):

Y-m-d H:i:s.f

Formatstring with separator character that describes how date variables are displayed in niota.

Sample value(s):

Y-m-d

Formatstring with separator character that describes how datetime variables displayed in niota.

Sample value(s):

Y-m-d H:i:s

• - date separator
• : time separator
• . milisecond separator

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

• , European
• . US