Page tree
Skip to end of metadata
Go to start of metadata

Syntax

MIDNIGHT(<date>)

Description

Returns the given date with a time of midnight (12:00:00 am).

Examples

Column1

MIDNIGHT returns

  Aug 2, 2011 03:55:03 PM

Aug 2, 2011 12:00:00 AM

Jul 2, 2011 03:55:09 PM

Jul 2, 2011 12:00:00 AM

Jun 2, 2011 03:55:00 PM

Jun 2, 2011 12:00:00 AM

May 2, 2011 03:55:55 PM

May 2, 2011 12:00:00 AM

Apr 2, 2011 03:55:58 PM

Apr 2, 2011 12:00:00 AM

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