CFGrid and Time Format

2006-09-14 Thread Patty Severski
Can I / How do I format the data that appears in cfgrid? Specifically : #TimeFormat(Date, “HH:MM:SS”)# ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion

Re: CFGrid and Time Format

2006-09-14 Thread Denny Valliant
I did it in the database. Depending on your database provider, could be the date_format() command, or something similar. e.g. mysql: SELECT date_format(somedates.aDateTime,'%m/%d/%Y') as someFormattedDateField FROM somedates :d On 9/14/06, Patty Severski [EMAIL PROTECTED] wrote: Can