SQL Server - TimeZone Convert - Asked By Mayank Tripathi on 25-Jul-13 04:32 AM

Hi All,

Please let me know the query to convert CST timezone to JST Timezone or any other timezone.

Currently using sql as below highlighted (getdate() is in CST).
         SELECT DATEADD(hh, 14, GETDATE());

Is there any other way where I need not to hardcode the hours.

Thanks & Regards,
Mayank T.