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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-11-11 : 10:32:18
|
| aigars writes "hi,is there any datetime format (or function) in SQL Serverthat returns amount of seconds spent/gone from 1970 likeunix_stamp in mysql?TIA,aigars matulis" |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2002-11-11 : 10:37:53
|
| Try this:select datediff(ss, '19700101', GetDate())/Andraax |
 |
|
|
|
|
|
UNIX_STAMP in SQL Server?