Piece of cake:

select dateadd(ss, 1114059600, '1/1/1970')

> -----Original Message-----
> From: Carl
[mailto:mssqldba-ezmlmshield-x63333915.[Email address protected]
> Sent: Thursday, April 28, 2005 5:56 AM
> To: LazyDBA Discussion
> Subject: Epoch time to SQL datetime conversion
>
>
>
>
>
> Hello all,
>
> Does anyone know of an easy way to convert from Epoch time to a SQL
> datetime format?
>
> Epoch Time to DateTime
> 1114059600 4/21/2005 12:00:00 AM
>
>
> Carl Phillips
> Regions Bank
> I.S. Engineer
> Proactive Monitoring and Problem Management
> W 334-956-6169
> C 334-799-8632
> 800-272-2867
>
>
> --------------------------------------------
> This e-mail and any files transmitted with it are the property of
> Regions Financial and/or its affiliates, are confidential, and are
> intended solely for the use of the individual or entity to whom
> this e-mail is addressed. If you are not one of the named
> recipient(s) or otherwise have reason to believe that you have
> received this message in error, please delete this message
> immediately from your computer. Any other use, retention,
> dissemination, forwarding, printing, or copying of this e-mail
> is strictly prohibited.
>
>
>
> ---------------------------------------------------------------------
> 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