niota

• AL32UTF8 - Oracle UTF8
• iso-8859-2 - Windows typical western character set
• UTF-8

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.

Sample values:

Y-m-d

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

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

• 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