You need to convert that to a date. When you store it in your db, you need to store it as a date or convert it before it's put into the DB. Please look up the date type of fields info.
On Mon, Feb 7, 2011 at 8:23 AM, Orlini, Robert <[email protected]> wrote: > > It is being output as <cfoutput query="get">. With this I get the 1630 not > the 16:30 as I need. > > -----Original Message----- > From: "Kelly" <[email protected]> > Sent: Monday, February 7, 2011 11:18am > To: "cf-talk" <[email protected]> > Subject: Re: 2r hour time format > > > What do you get when you just do > > #get.prodreccounttime# w/ out the formatting? > > 1630 or 1200? > > also no need for :ss unless you want to display seconds. > > > On 2/7/2011 11:14 AM, Orlini, Robert wrote: >> Thank you all. >> >> I looked over the livedocs for CF and formatted it this way: >> >> #TimeFormat(get.prodreccounttime, "hh:mm:ss")# >> >> However, instaed of the time "1630" becoming "16:30" I get "12:00:00". >> >> What did I do wrong here? >> >> RO >> >> -----Original Message----- >> From: "Robert Harrison"<[email protected]> >> Sent: Monday, February 7, 2011 10:25am >> To: "cf-talk"<[email protected]> >> Subject: RE: 2r hour time format >> >> >> CreateTime, TimeFormat() ... see CF documentation. >> >> Robert B. Harrison >> Director of Interactive Services >> Austin& Williams >> 125 Kennedy Drive, Suite 100 >> Hauppauge NY 11788 >> P : 631.231.6600 Ext. 119 >> F : 631.434.7022 >> http://www.austin-williams.com >> >> Great advertising can't be either/or. It must be&. >> >> Plug in to our blog: A&W Unplugged >> http://www.austin-williams.com/unplugged >> >> -----Original Message----- >> From: Orlini, Robert [mailto:[email protected]] >> Sent: Monday, February 07, 2011 10:17 AM >> To: cf-talk >> Subject: 2r hour time format >> >> >> Hello, >> >> Is there a way to format 24 hour time? Right now it dispalys as "1630 count >> time" for example. I would like it to read "16:30". Could not find an >> example wit he Format filter. >> >> Thanks. >> >> RO >> HWW >> >> >> >> >> >> >> >> > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341943 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
