Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Convertion of integer to Datetime format Expand / Collapse
Author
Message
Posted Wednesday, August 19, 2009 9:28 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:45 PM
Points: 23,081, Visits: 31,620
Lowell (8/19/2009)
After Dave inferred that it was the # seconds since 01/01/1970, it was pretty easy...but how the heck did he figure out the starting date?

Dave had you tripped over the same issue before? is it a common conversion from some other system(ie Oracle or DB2 or something?)


IIRC, this is how *nix stores date/time values.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #773660
Posted Wednesday, August 19, 2009 9:36 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 1:57 AM
Points: 1,949, Visits: 8,304
Lynn Pettis (8/19/2009)

IIRC, this is how *nix stores date/time values.


Yup , no magic mystical powers involved
http://en.wikipedia.org/wiki/Unix_time




Clear Sky SQL
My Blog
Kent user group
Post #773673
Posted Tuesday, May 28, 2013 1:07 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Saturday, June 21, 2014 5:43 AM
Points: 231, Visits: 314
I'm assuming the Unix server is always storing this in the time zone UTC, so if I want it in CST it is always -6 hours?


Post #1457212
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse