Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

lsParseDateTime throws error when called after setting locale to English / Australia

Description

Setting locale to the English - (Australia). then call the lsParseDateTime() throws error.

startOfYesterday = lsDateTimeFormat(yesterday, "yyyy-mm-dd") & " 00:00:00";

startOfYesterday_UTC = lsParseDateTime(date=startOfYesterday, timezone='UTC');

Error returned:

Message

can’t cast [2022-05-15 00:00:00] to date value

Detail

to add custom formats for en_AU, create/extend on of the following files [en-AU-datetime.df (for date time formats), en-AU-date.df (for date formats) or en-AU-time.df (for time formats)] in the following directory [/lucee/locales].

Environment

OS: Amazon Linux 2
Lucee: 5.3.8.206
Java: openjdk 11.0.13 2021-10-19 LTS
Tomcat: 9.0.59

Activity

Show:

Pothys - MitrahSoft 6 June 2022 at 08:30

Solution for the ticket:
The correct solution for this, we need to follow the instructions from the error details

Please create a file en-AU-datetime.df in web-context/lucee/locales with below content (ex- C:\lucee\tomcat\webapps\ROOT\WEB-INF\lucee\locales)

And restart lucee/tomcat.

So now the lsParseDateTime() with locale en_AU supports date-time string like 2022-05-15 00:00:00.

If you want to add more formats to be supported. Please append the format you want to support in a new line on that file like

So now these formats are supported by the lsParseDateTime() with en_AU.

The .df locale file needs java masks (ex: mm for Minute) for that from here SimpleDateFormat (Java Platform SE 7 ).

Pothys - MitrahSoft 19 May 2022 at 15:10

I've checked this ticket with the lucee latest version 5.3.10.8-SNAPSHOT. lucee server locale was in english (australian), lsParseDateTime() throws error for using the input date string with hyphen(-) as separator (ex: 01-01-2022).

The workaround was to use the date string with forward-slash(/) as a separator (ex: 01/01/2022) works fine. Also given the dateTime type value (ex: result of now(), ParseDateTime()) as input works fine.

Pothys - MitrahSoft 17 May 2022 at 11:09

Mailing list:

Fixed

Details

Assignee

Reporter

Priority

Labels

New Issue warning screen

Before you create a new Issue, please post to the mailing list first https://dev.lucee.org

Once the issue has been verified, one of the Lucee team will ask you to file an issue

Affects versions

Created 16 May 2022 at 10:44
Updated 6 June 2022 at 08:30
Resolved 6 June 2022 at 08:30