79121050

Date: 2024-10-24 08:39:20
Score: 2
Natty:
Report link

Certainly, you can. You will have to use GETUTCDATE() instead. Add hours and minutes to UTC date as per time zone.

e.g. South Africa +2:00, India +5:30

select dateadd("HH",2,getutcdate()) as 'South Africa datetime', dateadd("MINUTE",30,dateadd("HH",5,getutcdate())) as 'India datetime'

Reasons:
  • Low length (0.5):
  • No code block (0.5):
  • Low reputation (1):
Posted by: Ajay Manocha