Article ID: 1288, created on Oct 6, 2008, last review on Apr 18, 2012

  • Applies to:
  • Virtuozzo containers for Windows 4.0
  • Virtuozzo for Windows 3.5.1 SP1
  • Virtuozzo for Windows 3.5.1

Resolution

Use the following command:

print convert(varchar(30), DATEADD(second, <unixtime>, '01/01/1970'), 120)


e.g.


1) print convert(varchar(30), DATEADD(second, 1101505247, '01/01/1970'), 120)
2) go
2006-06-15 14:39:34

a06f7889a0f0293c5c75e7ee47fa3d96 1348db476c8a5844ffbef8d503db9c15 28d0f7cc091e3b9304fa556c03f9a940 965b49118115a610e93635d21c5694a8 d02f9caf3e11b191a38179103495106f 2897d76d56d2010f4e3a28f864d69223

Email subscription for changes to this article
Save as PDF