Date functions

The following table describes the supported date functions.

Function	Description
current_bigdatetime	Returns the current date and time on the server as a bigtime value with microsecond precision.
current_bigtime	Returns the current time on the server as a bigtime value with microsecond precision.
current_date	Returns the current date on the server.
current_time	Returns the current time on the server.
dateadd	Returns a date and time value after adding a specified interval to a date.
datediff	Returns the difference between two dates in a specified date part.
datename	Returns the name of a date part as a string.
datepart	Returns the integer value of a date part.
day	Returns an integer representing the day part in a date.
getdate	Returns the current system date and time.
getutcdate	Returns the current UTC date and time.
isdate	Returns 1 if the input expression is a valid datetime value; otherwise, 0.
month	Returns an integer representing the month part in a date.
year	Returns an integer representing the year part in a date.

For more information, see SAP ASE functions.