Description

This function rounds a DATE input down to the month by setting its DAY, HOUR, MINUTE, SECOND and MILLISECOND values to their ground state.

Эта функция округляет ввод ДАТЫ до месяца, устанавливая значения DAY, HOUR, MINUTE, SECOND и MILLISECOND в их основное состояние.

Syntax

ROUND_MONTH ( table.date_column )

Round dates down to the month:

Даты округления до месяца:

Query

ROUND_MONTH ( "Table1"."Date" )

Input

Date : DATE

Mon May 08 2006 23:59:59.999

Fri Dec 31 1999 23:59:59.999

Fri Jan 01 2016 00:59:59.000

Sat Jan 01 1994 00:00:00.000

Output

Column1 : DATE

Mon May 01 2006 00:00:00.000

Wed Dec 01 1999 00:00:00.000

Fri Jan 01 2016 00:00:00.000

Sat Jan 01 1994 00:00:00.000