CODEWITHSUNDEEP
javascriptcoldfusion
deetu
deetu

Reputation: 79

invalid date/time string: Sun Jun 03 2012 00:00:00 GMT+0100 (GMT Daylight Time) CFML

I'm trying to query to database using information from a html input. The format of the date is:

    Date {Sun Jun 03 2012 00:00:00 GMT+0100 (GMT Daylight Time)}

In the database query I used

    parseDateTime( arguments.start )

.. where arguments.start represents the date format shown above. But when I try to run the query, I get the response below from the web page:

invalid date/time string: Sun Jun 03 2012 00:00:00 GMT+0100 (GMT Daylight Time)

Upvotes: 1

Views: 1380

Answers (1)

awjr
awjr

Reputation: 636

Not sure what format you have there, but that is not a valid ISO 8601 time format. All ISO times formats are always GMT and are one of the following formats:

  • 1994-11-05T13:15:30Z
  • 1994-11-05T08:15:30-05:00

I would check whatever is giving you that string value.

Upvotes: 1

Related Questions