just noticed 5600.25 was seconds, not hours, so the initial cfset is off,
but the principle is the same.
-----Original Message-----
From: Caulfield, Michael [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 2:54 PM
To: CF-Talk
Subject: RE: Converting Seconds to Hours,Minutes,Seconds
Here's a fun, non-utilitarian way to do it while making code unreadable and
abusing your database (or that is to say in the tradition of YAPH):
<cfset t=5600.25/24>
<cfquery datasource="cfUserDSN" name="q">
select CAST(#t# as datetime) as mydate
</cfquery>
<cfoutput>
#decrementValue(datePart('y',q.mydate))# days,
#datePart('h',q.mydate)# hours, #datePart('n',q.mydate)# minutes,
#datePart('s',q.mydate)# seconds
</cfoutput>
{at least in SQL which stores date time as days since jan first, 1900)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
