Thanks Patrick, that did the trick. I hadn't even thought about using the
"dateadd" feature. The only issue I had after using this was to subtrack 5
hours to get the correct time, I guess that has something to do with GMT.

dateadd(s,1114059600,'1/1/1970')-'05:00:00' = 2005-04-21 00:00:00.000


Carl Phillips
Regions Bank
I.S. Engineer
Proactive Monitoring and Problem Management
W 334-956-6169
C 334-799-8632
800-272-2867



"Patrick Trongo "
<mssqldba-ezmlmsh
ield-x96967958.x1 To
[Email Address Removed] "LazyDBA Discussion"
.com> <[Email address protected]
cc
04/28/05 08:10 AM
Subject
RE: Epoch time to SQL datetime
conversion











Carl,

Try this.....

Epoch time is seconds... looks like you started on 1.1.1970 so....

select dateadd(s,1114059600,'1/1/1970') = 4/21/2005




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]




MS Sql Server LazyDBA home page