In CF, look at the TimeFormat function.
In MS SQL, you would use the CONVERT function; you db may or may not have
such a function.
-----Original Message-----
From: Tim Bahlke [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 01, 2000 3:01 PM
To: CF-Talk
Subject: Time from DB
I am receiving the time from my database as 14:00:00. How do I convert this
to 2:00:00.
I'm guessing there's got to be a function that does this but I can't seem to
found it.
Thanks,
Tim Bahlke
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
