timestamp data type

The system timestamp data type is an exact data type that is stored as 8 bytes. The stored offset has the same 1μS resolution as the time data type.

Syntax

timestamp <date> <time>

The input format of a timestamp value is a date value that is followed by a time value. By default, the date and time components are separated by a space (' '). You can change the delimiter by using the DateTimeDelim external table option. However, a delimiter between the date and time components is not required.

The date section must conform to the values of the -dateStyle and -dateDelim options that are in effect during the load job.

Errors

The date errors are the same as those for the date data type. The time errors are the same as those for the time data type.