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 functionsDisplay and formatting functions

Function syntax

ParseDateTime(date/time-string [, pop-conversion ])

See also

IsDateIsNumericDateSetLocale

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

  • pop: specifies that the date/time string is in POP format, which includes the local time of the sender and a time-zone offset from UTC. ColdFusion applies the offset and returns a value with the UTC time.
  • standard: (the default) function does no 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:

<cfset str = "Fri Jan 03 04:30:10 EDT 2014">
<cfset date = parsedateTime(str,"EEE MMM dd HH:mm:ss zzz yyyy")>

Another example:

<cfset string = "1997-07-16T19:20:30+01:00">
<cfset date = parseDateTime(string, "yyyy-MM-dd'T'HH:mm:ssX")>

 

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

<h3>ParseDateTime Example</h3> 
<cfif IsDefined("form.theTestValue")> 
<cfif IsDate(form.theTestValue)> 
<h3>The expression <cfoutput>#DE(form.theTestValue)#</cfoutput> is a valid date</h3> 
<p>The parsed date/time is: 
<cfoutput>#ParseDateTime(form.theTestValue)#</cfoutput> 
<cfelse> 
<h3>The expression <cfoutput>#DE(form.theTestValue)#</cfoutput> is not a valid date</h3> 
</cfif> 
</cfif> 

<form action="#CGI.ScriptName#" method="POST"> 
<p>Enter an expression, and discover if it can be evaluated to a date value. 
<input type="Text" name="TheTestValue" value="<CFOUTPUT>#DateFormat(Now())# 
#TimeFormat(Now())#</CFOUTPUT>"> 
<input type="Submit" value="Parse the Date" name=""> 
</form>

This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License  Twitter™ and Facebook posts are not covered under the terms of Creative Commons.

Legal Notices   |   Online Privacy Policy