> ## Documentation Index
> Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# 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.