Whatever message this page gives is out now! Go check it out!

Date and time functions

Last update:
May 18, 2026
FunctionDescription
CreateDateCreates a date/time object.
CreateDateTimeCreates a date/time object.
CreateODBCDateCreates an ODBC date object.
CreateODBCDateTimeCreates an ODBC date-time object.
CreateODBCTimeCreates an ODBC time object.
CreateTimeCreates a time variable.
CreateTimeSpanCreates a date/time object that defines a time period.
DateAddAdds units of time to a date.
DateComparePerforms a full date/time comparison of two dates.
DateConvertConverts local time to Coordinated Universal Time (UTC), or UTC to local time.
DateDiffDetermines the integer number of units by which date1 is less than date2.
DateFormatFormats a date value using U.S. date formats.
DatePartExtracts a part from a date value as a numeric.
DateTimeFormatFormats a datetime value using U.S. date and time formats.
DayDetermines the day of the month in a date.
DayOfWeekDetermines the day of the week ina date.
DayOfWeekAsStringDetermines the day of the week, in a date, as a string function.
DayOfYearDetermines the day of the year, ina date.
DaysInMonthDetermines the number of days in a month.
DaysInYearDetermines the number of days in a year.
FirstDayOfMonthDetermines the ordinal (day number, in the year) of the first day of the month in which a given date falls.
GetHttpTimeStringGets the current time, in the Universal Time Code (UTC).
GetTickCountReturns the current value of an internal millisecond timer.
GetTimeZoneInfoGets local time zone information for the computer on which it is called, relative to Universal Time Coordinated (UTC).
HourGets the current hour of the day.
IsDateDetermines whether a string or Java object can be converted to a date/time value.
IsDateObjectDetermines whether a value is a date/time object.
IsLeapYearDetermines if a year is a leap year.
IsNumericDateEvaluates whether a real number is a valid representation of a date (date/time object).
LSDateFormatFormats the date part of a date/time value in a locale-specific format.
LSIsDateDetermines whether a string is a valid representation of a date/time value in the current locale.
LSParseDateTimeConverts a string that is a valid date/time representation in the current locale into a date/time object.
LSTimeFormatFormats the time part of a date/time string into a string in a locale-specific format.
MinuteGets the value of the minute from a date/time object.
MonthGets the value of the month in a date/time object.
MonthAsStringDetermines the name of the month that corresponds to month_number.
NowGets the current date and time of the computer running the CFML server.
ParseDateTimeParses a date/time string according to the English (U.S.) locale conventions.
QuarterCalculates the quarter of the year in which a date falls.
SecondExtracts the ordinal for the second from a date/time object.
SetDaySets the day on the Date object.
SetHourSets the hour on the Date object.
SetMinuteSets the minute on the Date object.
SetMonthSets the month on the Date object.
SetSecondSets the second on the Date object.
SetYearSets the year on the Date object.
TimeFormatFormats a time value using US English time formatting conventions.
WeekDetermines the week number in a year.
YearGets the year value.

Share this page

Was this page helpful?
We're glad. Tell us how this page helped.
We're sorry. Can you tell us what didn't work for you?
Thank you for your feedback. Your response will help improve this page.

On this page