Could someone enlighten me as to when one would use epochal time, which I gather is seconds elapsed since some arbitrary time (which often appears to be 1 Jan 1970)?

-----Original Message-----
From: Patrick Trongo
[mailto:mssqldba-ezmlmshield-x19018817.[Email address protected]
Sent: Thursday, April 28, 2005 11:12 AM
To: LazyDBA Discussion
Subject: RE: Epoch time to SQL datetime conversion



You probably already thought of this, but just in case....


use 12/31/69 19:00 as your seed time...


declare @epochlocal as integer

set @epochlocal = 1114059600

select @epochlocal Epoch, dateadd(s,@epochlocal,'12/31/1969 19:00:00')
Calendar


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