Date And Time Functions

namedescription
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. You can add or subtract it from other date-time objects and use it with the cachedWithin attribute of cfquery.
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. The function uses the daylight savings settings in the executing computer to compute daylight savings time, if necessary.
dateDiffDetermines the integer number of units by which date1 is less than date2.
dateFormatFormats a date value using U.S. date formats. For international date support, use LSDateFormat.
datePartExtracts a part from a date value.
dayDetermines the day of the month, in a date.
dayOfWeekDetermines the day of the week, in a date.
dayOfWeekAsStringDetermines the day of the week, in a date, as a string function.
dayOfYearDetermines the day of the year, in a 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). UTC is the mean solar time of the meridian of Greenwich, England, used as the basis for calculating standard time throughout the world.
hourGets the current hour of the day.
isDateDetermines whether a string or Java object can be converted to a date/time value.
isLeapYearDetermines whether 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.
minuteExtracts the minute value from a date/time object.
monthExtracts the month value from 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 ColdFusion server. The return value can be passed as a parameter to date functions such as DaysInYear or FirstDayOfMonth.
parseDateTimeParses a date/time string according to the English (U.S.) locale conventions. (To format a date/time string for other locales, use the LSParseDateTime function.)
quarterCalculates the quarter of the year in which a date falls.
secondExtracts the ordinal for the second from a date/time object.
timeFormatFormats a time value using U.S. English time formatting conventions.
weekFrom a date/time object, determines the week number within the year.
yearFrom a date/time object, gets the year value.