Why does Coldfusion DateTime return weird values?

Question

I am trying to use the ColdFusion DateFormat function. Can someone tell me why to do this:

#DateFormat( now(), "YYYY-MM-DD HH:MM:SS")#

returns this:

  2012-07-17 16:07:666

Why 666 milliseconds? something diabolical ???

+4

frequent Jul 17 '12 at 15:02

2 answers

I prefer to use Java SimpleDateFormat, where the date mask is case sensitive.

 <cfscript> createObject('java','java.text.SimpleDateFormat').init('yyyy-MM-dd HH:mm:ss.SSS').format(now()); </cfscript>

eg. 2010-07-19 11:46:12.029

+1

Mike causer Jul 19 '12 at 1:47

Sean coyne · Accepted Answer · 2012-07-17T15:04:14+0000

DateFormat does not format time. Use TimeFormat for time.

Edit

Use this code to display the date and time.

 #dateFormat(now(),'YYYY-MM-DD')# #timeFormat(now(), 'HH:MM:SS')#