SQL Reference Guide

TO_TIMESTAMP function (extension)

Syntax

TO_TIMESTAMP ( timestamp_lit )

Description

The scalar function TO_TIMESTAMP converts the given timestamp literal to a timestamp value.

Example

SELECT * FROM orders

WHERE order_timestamp > TO_TIMESTAMP('4/18/95 10:41:19')

Notes

• The result is of type TIMESTAMP.
• Supply the timestamp literal in any valid format. See Timestamp Literals for valid formats of TIMESTAMP literals.