URGENT: UNIX DATE FORMAT CONVERION TO SQL SERVER

[Waqar]

I HAVE ONE COLUMN CONTAING THE INTEGER TYPE DATA COMING in UNIX DATE FORMAT. NEED TO CONVERT IT TO THE SQL SERVER DATE TIME FORMAT.

NOTE: UNIX IS STORING THE DATE IN SECONDS STARTING FROM 1970/1/1

ANYBODY CAN HELP ME TO SOLVE THIS PROBLEM.

e.g. The UNIX date time is 973101026 need to be converted to SQL DATE TIME

[Ananth]

If you're sure of the fact that the date is in seconds from 1/1/1970, use the dateadd function :

select dateadd(second, 973101026, '01/01/1970&#39

---------------------------
2000-11-01 17:50:26.000




------------
Waqar at 5/9/01 1:19:39 PM

I HAVE ONE COLUMN CONTAING THE INTEGER TYPE DATA COMING in UNIX DATE FORMAT. NEED TO CONVERT IT TO THE SQL SERVER DATE TIME FORMAT.

NOTE: UNIX IS STORING THE DATE IN SECONDS STARTING FROM 1970/1/1

ANYBODY CAN HELP ME TO SOLVE THIS PROBLEM.

e.g. The UNIX date time is 973101026 need to be converted to SQL DATE TIME

[MAK]

Here we go.


select dateadd(ss,973101026,"01/01/1971&#34

-MAK


------------
Waqar at 5/9/01 1:19:39 PM

I HAVE ONE COLUMN CONTAING THE INTEGER TYPE DATA COMING in UNIX DATE FORMAT. NEED TO CONVERT IT TO THE SQL SERVER DATE TIME FORMAT.

NOTE: UNIX IS STORING THE DATE IN SECONDS STARTING FROM 1970/1/1

ANYBODY CAN HELP ME TO SOLVE THIS PROBLEM.

e.g. The UNIX date time is 973101026 need to be converted to SQL DATE TIME