[SQL]DefaultTimestampFormat

Sets the formatting pattern being used by SQLGetField function for converting database date/time values to strings.

Please note that only main date/time data types are affected by this parameter. For SQL Server it works for DateTime and SmallDateTime, while for MS Access it works for Date/Time type. If it is necessary to use the parameter for converting other parameters, please use conversion macros to main types in your SQL queries. For example in T-SQL, the conversion may use CONVERT macro: SELECT CONVERT(DateTime, MyDateColumn) FROM MyTable.

Allowable Values:

Any valid "format" parameter value for the function TimestampToStr.

0 - Short time format, hh:mm

1 - Long time format, hh:mm:ss

2 - Short date format, dd/MM/yyyy

3 - Long date format, dddd, dd MMMM yyyy.

4 - Short date & short time format, dd/MM/yyyy hh:mm

5 - Short date & long time format, dd/MM/yyyy hh:mm:ss

6 - Long date & short time format, dddd, dd MMMM yyyy hh:mm

7 - Long date & long time format, dddd, dd MMMM yyyy hh:mm:ss

8 - Month day format, dd MMMM

9 - Year month format, MMMM yyyy

10 - RFC1123 format, ddd, dd MMM yyy hh:mm:ss GMT

11 - Sortable date time format, yyyy-MM-ddThh:mm:ss

12 - Short universal format, yyyy-MM-dd hh:mm:ss

13 - Long universal format, dddd, dd MMMM yyyy hh:mm:ss

Default Value:

11

See Also

SQL Parameters