RE: Epoch time to SQL datetime conversion

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



MS Sql Server LazyDBA home page