Date Display problem in ColdFusion

cfquery, coldfusion, datetime

Solution

You could use something like:

<cfquery datasource="northwind" name="queryDB">
  SELECT date_used, time_used
  FROM invoicesTable
</cfquery>

<cfoutput query="queryDB">
#DateFormat(date_used, "m/d/yyyy")#
#TimeFormat(time_used, "h:mm tt")#
</cfoutput>

I think this is what you want.

You could use

#DateTimeFormat(Now(), "mmm d, yyyy","h:mm TT")#

to have datetime format

Happy coding

Problem

When I retrived a Date field in TOAD it displayed like is '`1/18/2038 9:14:07 PM`', But when I rertrived in Coldfusion using cfquery and displayed using , then I got the date on screen like '`2038-01-18 21:14:07.0`'. Does anyone have idea why it displayed in different format? Is there anyway we can make it display like TOAD format? I am using Oracle 10g DB and coldfusion 8

Original source