Home Forums SQL Server 2005 SQL Server 2005 Strategies Convertion of integer to Datetime format RE: Convertion of integer to Datetime format
harishchede
SSC-Addicted
Points: 401
More actions
August 18, 2009 at 4:49 am
#1040724
Thanks a lot it worked
thanks to all who supported
it got resolved by
putting the query
select (1231151827/60)
select 20519197/60
select 341986/24
select dateadd(dd,14249,'19700101')