0

I want to convert UTCdatetime in to local datetime. I got it but when I set timezone (UTC-05:00) Eastern Time (US & Canada), then it shows me 1 hour difference. I want exact time as local time.

Cœur
  • 37,241
  • 25
  • 195
  • 267
mahesh
  • 91
  • 9
  • MySQL or SQL Server? Too often dbms products are far from ANSI SQL compliant when it comes to date/time. (These products have their own versions...) – jarlh Sep 11 '15 at 07:34
  • SQL Server 2008 or greter – mahesh Sep 11 '15 at 07:36
  • possible duplicate of : http://stackoverflow.com/questions/8038744/convert-datetime-column-from-utc-to-local-time-in-select-statement – Deepshikha Sep 11 '15 at 07:46
  • Possible duplicate of [Convert Datetime column from UTC to local time in select statement](https://stackoverflow.com/questions/8038744/convert-datetime-column-from-utc-to-local-time-in-select-statement) – CodeNotFound May 02 '18 at 08:02

0 Answers0