Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  unix time in mssql?

Author  Topic  plocke Starting Member 15 Posts Posted - 2001-11-13 : 02:09:26 Unixtime the current time measured in the number of seconds since the Unix Epoch (January 1 1970 00:00:00 GMT). can i get this in mssql? i tried all these to no avail select convert(varchar, getdate(), 101) as f101 select convert(varchar, getdate(), 121) as f121 etc.