Category: ASE: Functions: Date and Time Functions

day()

The Date & Time Function day() returns the value of the day of a date passed via the parameter "date expression" without leading zeros. The return value is of the datatype integer. The function day() is available in ASE® starting with version 15.0.

Syntax of the Datatype Conversion Function day()

    day(date expression)
    

The parameter "date expression" of the Date & Time Function day()

date expression
The parameter "date expression" is a placeholder for a date which can be passed in the format of a datetime, smalldatetime, date (starting with ASE® version 15.0), time (starting with ASE® version 15.0) Datentyps or as a character string in date format. The parameter "date expression" must be set in quotes.

Example for the Datatype Conversion Function day()

    select day(getdate())

    go

    -----

    
    

Returns the current number of the day of the month of the operating system without leading zeros.

    select day()

    go

    -----

    
    

Returns the current number of the day of the month of the operating system without leading zeros. The function day() comparable to the datepart(dd, date expression) function.

See also:

ASE T-SQL - Aggregate Functions,
Date and Time Functions,
dateadd(),
datediff(),
datename(),
datepart(),
date_part,
getdate(),
month(),
style numbers,
year().