Description
Parses 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.)
Returns
A date/time object
Category
Date and time functions, Display and formatting functions
Function syntax
ParseDateTime(date/time-string [, pop-conversion ])
See also
IsDate, IsNumericDate, SetLocale
Parameters
Parameter |
Description |
||
|---|---|---|---|
date/time string |
A string containing a date/time value formatted according to U.S. locale conventions. Can represent a date/time in the range 100 AD-9999 AD. Years 0-29 are interpreted as 2000-2029; years 30-99 are interpreted as 1930-1999. |
||
pop-conversion |
Apart from these 2 values, this parameter allows you to specify the format in which to parse the given string. Valid letters that can be used to specify the format are described here http://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html For instance:
Another example:
|
Usage
This function is similar to CreateDateTime, but it takes a string instead of enumerated date/time values. These functions are provided primarily to increase the readability of code in compound expressions.To calculate a difference between time zones, use the GetTimeZoneInfo function. To set the default display format of date , time, number, and currency values, use the SetLocale function.
Example
<cfscript>
dateTimeVar = dateTimeFormat(now(), "yyyy.MM.dd HH:nn:ss ")
writeOutput(parseDateTime(dateTimeVar))
</cfscript>
Output
{ts '2018-11-06 07:02:37'}