Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

time difference Expand / Collapse
Posted Tuesday, April 27, 2010 8:13 AM


Group: General Forum Members
Last Login: Monday, March 14, 2016 9:29 PM
Points: 193, Visits: 343
Can anyone tell me how to findthe time difference between two countries using sql server

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



Group: General Forum Members
Last Login: Wednesday, February 10, 2016 11:50 AM
Points: 6,897, Visits: 13,559
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.

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