Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

Syntax

TIMESTAMP(<date>)

Description

Difference, measured in milliseconds, between the current time and midnight, January 1, 1970 UTC.

Examples

Column1

TIMESTAMP returns

Oct 15, 2010 4:34:34 AM

1,287,110,074,001

Sep 26, 2010 12:33:25 PM

1,285,497,205,000

Auf 31, 2011 11:30:45 AM

1,314,783,045,000

Datameer always uses the following format:

Three character month abbreviation (space) two digit day (comma)(space) four digit year (space) two digit hour (colon) two digit minute (colon) two digit second (space) two character meridiem notation.

(e.g., 12.01.2012 gets transferred to Jan 12, 2012 12:00:00 AM)

When selecting a pattern, you select the way the data gets parsed (your input format, this can be connected to your systems representation of dates and times).

  • No labels