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
 SQL Server Development (2000)
 Unix timestamp

Author  Topic 

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2004-12-29 : 10:30:32
Anybody know how to create a unix timestamp in either pure sql or in asp/vbscript?

--
Lumbago
"Real programmers don't document, if it was hard to write it should be hard to understand"

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2004-12-29 : 10:34:59
Hehe, that didn't take long...Google is your friend: SELECT DATEDIFF(ss, '1970-01-01 00:00:00', GETDATE())

--
Lumbago
"Real programmers don't document, if it was hard to write it should be hard to understand"
Go to Top of Page
   

- Advertisement -