TIMESTAMP: Converting to a Timestamp

How to:

The TIMESTAMP function converts its argument to a timestamp. The argument type can be character, date, time, or timestamp.


Top of page

x
Syntax: How to Convert to a Timestamp
TIMESTAMP(arg)

where:

arg

character string, date, time, or timestamp

Is the input value.

This function returns a timestamp.



Example: Converting to a Timestamp

TIMESTAMP converts a value to a timestamp. This example,

TIMESTAMP('2004-06-24')

returns 20040624000000.

This example,

TIMESTAMP('11:22:33')

returns 20010101112233, if the current date is January 1, 2001.


iWay Software