Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Syntax

STARTOFMONTH(<date>)

Description

Returns the date of the first day of month (starting the morning at 00:00:00 / 12:00:00 AM) for the given date.

Examples

DateSTARTOFMONTH returns
Oct 15, 2002 04:36:34Oct 1, 2002 12:00:00 AM
Apr 17, 2012 07:27:12Apr 1, 2012 12:00:00 AM
Jul 5, 1979 11:59:59Jul 1, 1979 12:00:00 AM


Info

Datameer X 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).