Skip to main content Skip to complementary content

TimestampFormat

The format defined replaces the date and time formats of the operating system (regional settings).

Syntax:  

TimestampFormat

Example:  

The following examples use 1983-12-14T13:15:30Z as timestamp data to show the results of different SET TimestampFormat statements. The date format used is YYYYMMDD and the time format is h:mm:ss TT. The date format is specified in the SET DateFormat statement and the time format is specified in the SET TimeFormat statement, at the top of the data load script.

Results
Example Result

SET TimestampFormat='YYYYMMDD';

19831214

SET TimestampFormat='M/D/YY hh:mm:ss[.fff]';

12/14/83 13:15:30

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

14/12/1983 13:15:30

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff] TT';

14/12/1983 1:15:30 PM

SET TimestampFormat='YYYY-MM-DD hh:mm:ss[.fff] TT';

1983-12-14 01:15:30

Examples: Load script