Article ID: 1288, created on Apr 27, 2009, last review on Apr 28, 2012

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

Resolución

Use el siguiente comando:

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


Por ejemplo:


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