Search code examples
coldfusioncoldfusion-9

How to format this date as a string

Here is my scenario. I am getting this date from a database:

11-AUG-15 10.38.00.000000000 AM

Is there any way to format this string to look something similar to mm/dd/yy?

So far I have tried the following with no luck:

  • DateFormat()
  • CreateODBCDate()
  • LSParseDateTime()

Every time I use one of the above, I get the following error:

11-AUG-15 10.38.00.000000000 AM is an invalid date or time string.

Any advise will be greatly appreciated.

Thanks!

Solution 
  • parseDateTime("11-AUG-15 10.38.00.000000000 AM", "dd-MMM-yy hh.mm.ss.S aa");

    Run me: http://trycf.com/gist/aac6d63777ae1b0e9aa3/acf?theme=monokai

    Then you are free to use DateFormat() or DateTimeFormat()to format the date object.