Description

DateTime rounding functions round down the subordinates of the chosen time unit into the ground state. They can be applied to DATE columns and always return a DATE column.

The ground states are:

• MONTH: 01
• DAY: 01
• HOUR: 00
• MINUTE: 00
• SECOND: 00
• MILLISECOND: 000

The ROUND_WEEK function is handled slightly different: This function also rounds down the HOUR, MINUTE, SECOND and MILLISECOND values, but the DAY value will not be in its ground state. Instead, the day will be chosen as the Monday of the week of that date.

Syntax:

ROUND_YEAR ( table.date_column )

ROUND_MONTH ( table.date_column )

ROUND_WEEK ( table.date_column )

ROUND_DAY ( table.date_column )

ROUND_HOUR ( table.date_column )

ROUND_MINUTE ( table.date_column )

ROUND_SECOND ( table.date_column )