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 - 2001-05-08 : 22:12:48
|
Yay writes "Hi,
I am importing a text file generated from a unix application. One of the field in that text file is in Unix Time format (seconds since 1/1/70). How do i convert it to SQL Time? Is there a function in SQL or any existing scripts that i could use?
Here is an example of the field that has unix time format :
989239960
989240350
Thanks for your help." |
|
|
|
|
|
Unix Time convert to SQL time