tony
-----Original Message-----
From: Jeff Small [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 1:19 PM
To: CF-Talk
Subject: Re: Quick Question, RE: Datatype and future date/time calculation
> so lets say start time was today, now().
>
> <cfset beginTime = dateDiff('s','01/01/1970 00:00:00.000',now())>
>
> that will give you a value something like this....
>
> 1080131574
>
> throw that into an integer column called beginTime
>
> and you can translate that back to a "human readable" date time like
> this
>
> <cfset epochToDateTime = dateAdd('s',beginTime,'01/01/1970
> 00:00:00.000')>
>
> which will return
>
> {ts '2004-03-24 12:35:02'}
>
> and you can dress that up with...
>
> dateFormat() as you know im sure.
>
> tony
Okay Okay, lemme digest this...I'll post after lunch, while I print this out
and take a couple minutes to look it over. I *think* I get where you're
coming from, but I wanna pore over this a bit more.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
