ETL: GetDay

Extract the day-of-month component (1 through 31) from a datetime expression. Use GETDAY for date-based filtering and grouping in ETL pipelines.

Description

Returns the day of a month from a datetime expression.

Syntax

GetDay(datetime_expression)

Examples

GetDay(ToDate('2013-09-10T08:02:31.667Z')) returns 10

Return value datatype

Integer

Impact of null value

If input is null, returns null.