> 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]

Reply via email to