ansaurus

Question

Answer 1

+5 A:

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

Ravia 2010-01-07 15:41:18

I have Date and time combined in DB like "1/18/2038 9:14:07 PM". In above example, it retrieving seperatly

CFUser 2010-01-07 15:56:33

@CFUser, that's how it works in CF: dates and times formatting functions accept date object but return only own part. You can always wrap both functions into the single UDF, like FormatDateTime().

Sergii 2010-01-07 16:21:09

I am not aware of a built-in function named `DateTimeFormat()`. Ben Nadel has an implementation on his blog, though. http://www.bennadel.com/blog/717-ColdFusion-DateTimeFormat-Utility-Function.htm

Tomalak 2010-01-07 16:55:28

@Tomalak Yeah, I was talking about exactly such type of solution.

Sergii 2010-01-07 20:09:34

Answer 2

+3 A:

The Coldfusion datetime variable you retrieved from your database has all the information you are requesting. Coldfusion will automatically convert it to a variety of outputs depending on your need using some built in functions.

<!--- Assuming that 'myDateTime' is a datetime variable retrieved from cfquery --->
<cfoutput>
    <!--- Outputs: 1/7/2010 --->
    #dateFormat(myDateTime, "m/d/yyyy")#
    <!--- or use a mask shortcut - only outputs two digit year: 1/7/10 --->
    #DateFormat(myDateTime, "short")#

    <!--- Outputs: 8:47:14 AM --->
    #timeFormat(myDateTime, "h:mm:ss tt")#
    <!--- or use the shortcut: --->
    #TimeFormat(myDateTime, "medium")#
</cfoutput>

If you must construct a single string with the TOAD format, then you may concatenate the output of the dateFormat() and timeFormat() strings.

<!--- Outputs: '1/7/2010 8:47:14 AM' --->
<cfset toadFormat = dateFormat(myDateTime, "m/d/yyyy") & " " & TimeFormat(myDateTime, "medium")>

This saves a bit of hassle if you'll be using this data many times. However for most needs this is unnecessary as the original myDateTime variable contains all the information needed for all purposes other than display output.

More about DateFormat() and TimeFormat() from Adobe. More about DateFormat and TimeFormat shortcuts from Pete Freitag.

Dan Sorensen 2010-01-07 16:58:51

I wasn't aware of those mask shortcuts. Thanks for that.

Al Everett 2010-01-07 18:40:12

ansaurus

tags:

views:

answers:

Date Display problem in ColdFusion

related questions