2.10 COMPUTETIMESTAMP

Use COMPUTETIMESTAMP to convert a datetime string to Julian format.

Default

None

Syntax

COMPUTETIMESTAMP string

string

A datetime string in the format of:

[[yy]yy-mm-dd] [hh[:mm][:ss]]

Example

COMPUTETIMESTAMP 2005-01-01 12:00:00

This example returns the following:

2005-01-01 12:00:00 is JulianTimestamp 211971340800000000