Date and Time Function List

Review the list of date and time functions.

Function

Description

uDate

Returns a year, month, and day from a date in the format YYYY-MM-DD

uDateTime

Returns a year, month, and day from a date in the format YYYY-MM-DD HH.MM.SS

uDay

Returns the day number of the date specified

uDayOfYear

Returns the number of days since the beginning of the year

uHour

Returns the hour of the date specified

uQuarter

Returns the quarter of the year

uIsoWeek

Returns the week number defined by ISO 8601

uJuliandate

Returns the number of days since noon in Greenwich on November 24, 4714 B.C, in the format DDDD.DDDD

uMinute

Returns the minute of the date specified

uMonth

Returns the month of the name specified

uMonthName

Returns the name of month of the date specified, in the current locale language

uMonthNameShort

Returns the short form of the name of month of the date specified, in the current locale language

uSeconds

Returns the second of the date specified

uTime

Returns the time part from a date in, the format HH.MM.SS

uTimeDiffMs

Returns the difference between two dates, in milliseconds

uWeek

Returns the week of the date specified

uWeekday

Returns the weekday of the date specified

uWeekdayName

Returns the weekday name of the date specified, in the current locale language

uWeekdayNameShort

Returns the short form of the weekday name of the date specified in the current locale language

uYear

Returns the year of the date specified

Note:

Refer to Date and Time for detailed information about the possible modifier arguments.