Quoting Paul Sinclair <[EMAIL PROTECTED]>: > > I have a cfgrid and one of the cfgridcolumns is a time field. I'd > like to output the column showing the time in the format "08:10" (for > example). > Right now it is outputting as "1899-12-30 08:10:00". I can't figure > out how to use the timeformat function to output the display for the > relevant column or even it is possible to do it.
Make sure you get the time as a correctly formatted string out ot the query: SELECT EXTRACT(HOUR FROM timefield) || ':' || EXTRACT(MINUTE FROM timefield) AS formattedtime If your database does not support SQL syntax, check the manual for equivalents. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
