ParseDateTime()

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.)

ParseDateTime( date=object, format=string, timezone=timezone );

Returns: DateTime

Argument Description
date
object, required

A string containing a date/time value formatted according to U.S. locale conventions.
format
string, optional

Mask that has to be used for formatting. the following characters are pattern letters (case sensitive) representing the components of a datetime string. All other characters are not interpreted

  • a,..,aaaa: AM/PM marker (see also "t" and "tt"; Example:AM)
  • d: Day in month, no leading zero for single-digit days (Example:3)
  • dd: Day in month, leading zero for single-digit days (Example:03)
  • D: Day in year, no leading zero for single-digit days (Example:4)
  • DD: Day in month, leading zero for single-digit days (Example:04)
  • DDD: Day in month, 2 leading zero for single-digit days (Example:004)
  • E,EE,EEE: Day of week as a three-letter abbreviation (Example:Tue)
  • EEEE: Day of week as its full name (Example:Tuesday)
  • F: Day of week in month, no leading zero for single-digit days (Example:4)
  • FF: Day of week in month, leading zero for single-digit days (Example:04)
  • G,GG: Era designator (Example:AD)
  • h: Hour in am/pm (1-12), no leading zero for single-digit hours (Example:3)
  • hh: Hour in am/pm (1-12), leading zero for single-digit hours (Example:03)
  • H: Hour in day (0-23), no leading zero for single-digit hours (Example:14)
  • HH: Hour in day (00-23), leading zero for single-digit hours (Example:14)
  • k: Hour in day (1-24), no leading zero for single-digit hours (Example:15)
  • kk: Hour in day (1-24), leading zero for single-digit hours (Example:15)
  • K: Hour in am/pm (0-11), no leading zero for single-digit hours (Example:2)
  • KK: Hour in am/pm (0-11), leading zero for single-digit hours (Example:02)
  • l,L: milliseconds, with no leading zeros (Example:3)
  • ll,LL: milliseconds, leading zero for single-digit days (Example:03)
  • lll,LLL: milliseconds, 2 leading zero for single-digit days (Example:003)
  • m,M: Month as digits, no leading zero for single-digit months (Example:6)
  • mm,MM: Month as digits, leading zero for single-digit months (Example:06)
  • mmm,MMM: Month as a three-letter abbreviation (Example:Jun)
  • mmmm,MMMM: Month as its full name (Example:June)
  • n,N: minutes in hour, no leading zero for single-digit minutes (Example:3)
  • nn,NN: minutes in hour, leading zero for single-digit minutes (Example:03)
  • s,S: seconds in minute, no leading zero for single-digit seconds (Example:3)
  • ss,SS: seconds in minute, leading zero for single-digit seconds (Example:03)
  • t,T: one-character time marker string (Example:P)
  • tt,TT: multiple-character time marker string (Example:PM)
  • w: Week in year, no leading zero for single-digit hours (Example:27)
  • ww: Week in year, leading zero for single-digit hours (Example:27)
  • W: Week in month, no leading zero for single-digit hours (Example:2)
  • WW: Week in month, leading zero for single-digit hours (Example:02)
  • y,yy,yyy: Year as last two digits, leading zero for single-digit (Example:09)
  • yyyy: Year represented by four digits (Example:2009)
  • z,zz,zzz: General time zone as a 3 to 4 letter abbreviation (Example:PST)
  • zzzz: General time zone as its full name (Example:Pacific Standard Time)
  • Z,..,ZZZZ: RFC 822 time zone (Example:-0800)

The following masks can be used to format the full date and time and may not be combined with other masks:

  • short: equivalent to "m/d/y h:mm tt"
  • medium: equivalent to "mmm d, yyyy h:mm:ss tt"
  • long: medium followed by three-letter time zone; i.e. "mmmm d, yyyy h:mm:ss tt zzz"
  • full: equivalent to "dddd, mmmm d, yyyy h:mm:ss tt zz"
  • ISO8601: equivalent to "yyyy-mm-dd'T'HH:nn:ss'Z'Z"

Alias: popConversion
timezone
timezone, optional

A datetime object is independent of a specific timezone; it is only an offset in milliseconds from 1970-1-1 00.00:00 UTC (Coordinated Universal Time).

The timezone only comes into play when you need specific information like hours in a day, minutes in a hour or which day it is as these calculations depend on the timezone.

A timezone must be specified in order to translate the date object to something else. If you do not provide the timezone in the function call, it will default to the timezone specified in the Lucee Administrator (Settings/Regional), or the timezone specified for the current request using the function setTimezone().

You can find a list of all available timezones in the Lucee administrator (Settings/Regional). Some examples of valid timezones include:

  • AGT (for time in Argentina)
  • Europe/Zurich (for time in Zurich/Switzerland)
  • HST (Hawaiian Standard Time in the USA)
  • JVM (JVM / Server Default Timezone)

Examples

datetime = dateTimeFormat(now(), "yyyy.MM.dd HH:nn:ss");
dump(ParseDateTime(datetime));

See also