Time Value - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Programming

Time Value

Author

Topic

sanjay5219
Posting Yak Master

240 Posts

Posted - 2010-01-25 : 16:51:12

Dear All,

I have transfer some data from Informix to Sql Server.Now in one table there is a column in_time and i am getting these values
1264147047
1264147089
1264147161
1264147178
1264147183

can any body tell me that how to convert this to time

X002548
Not Just a Number

15586 Posts

Posted - 2010-01-25 : 17:12:08

It's gotta be seconds....


DECLARE @dok_dt int
SELECT @dok_dt = 1047034683
SELECT DATEADD(s, @dok_dt, '19700101 00:00:00')

http://www.nationmaster.com/encyclopedia/Unix-epoch

Arnold hooked me up a while ago..I think this is what you want

http://www.sqlteam.com/forums/pop_profile.asp?mode=display&id=3680

My Blog

http://weblogs.sqlteam.com/brettk/archive/2005/06/02/5528.aspx

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

sanjay5219
Posting Yak Master

240 Posts

Posted - 2010-01-25 : 17:22:21

Done

X002548
Not Just a Number

15586 Posts

Posted - 2010-01-26 : 11:08:03

quote:
Originally posted by sanjay5219

Done

I guess that means Thank you

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

sanjay5219
Posting Yak Master

240 Posts

Posted - 2010-01-26 : 11:53:29

Of Course Thanks a lot

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources