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

time difference Expand / Collapse
Author
Message
Posted Tuesday, April 27, 2010 8:13 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 10:09 AM
Points: 189, Visits: 333
Can anyone tell me how to findthe time difference between two countries using sql server

Thanks in advance
NAveen
Post #911154
Posted Tuesday, April 27, 2010 10:24 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 9:38 AM
Points: 6,908, Visits: 12,624
It depends on the table structure you've used to store this information...
But if you're looking for time zones per country, SQL Server is the wrong source to start with, since there is no system table with this information. Google would be better... Once you found a site with the information you need, set up a table in SQL Server and load the data into that table.




Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question
How to post performance related questions
Links for Tally Table , Cross Tabs and Dynamic Cross Tabs , Delimited Split Function
Post #911286
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse