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

Converting Quartz.Net time columns to datetime Expand / Collapse
Author
Message
Posted Thursday, March 13, 2014 7:53 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 7:42 AM
Points: 1,928, Visits: 1,013
Then what time are you expecting?

Here is an example of adding 5 hours and 30 minutes as minutes with results from SQL 2008
 SELECT dateadd(n,330,CAST(635302120392663258/864000000000.0 - 693595.0 AS DATETIME)),
CAST(635302120392663258/864000000000.0 - 693595.0 AS DATETIME)

results: 2014-03-12 14:37:19.263, 2014-03-12 09:07:19.263

Post #1550712
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse