DAY,MONTH,and YEAR

The DAY, MONTH, and YEAR functions take a date expression as input, and returns the day, month, and year, respectively, from the date expression.

Syntax

DAY (date_expression)

MONTH (date_expression)

YEAR (date_expression)

Remarks

•

The date_expression cannot be an empty string.

•

Leading zeroes in a date or month are ignored in the output.

•

If the input is NULL, the output is also NULL.

Name and Format	Data Type of date_expression	Output Type	Output Value
DAY (date_expression)	DATE, TIMESTAMP	INTEGER	Between 1 and 31.
	NULL	NULL	NULL
MONTH (date_expression)	DATE, TIMESTAMP	INTEGER	Between 1 and 12.
	NULL	NULL	NULL
YEAR (date_expression)	DATE, TIMESTAMP	INTEGER	Between 1 and 9999.
	NULL	NULL	NULL

Example

SELECT DAY (orders.OrderDate) OrderDate, 

MONTH (orders.OrderDate) OrderMonth, 

YEAR (orders.OrderDate) OrderYear 

FROM /shared/examples/ds_orders/orders orders

Top