How can I convert timezones in SQL?

How can I convert timezones in SQL?

You can use the AT TIME ZONE clause in SQL Server to convert between time zones. For example, SELECT YourDateTimeColumn AT TIME ZONE 'UTC' AT TIME ZONE 'Pacific Standard Time'.

What if I have a timestamp without a timezone?

If you have a timestamp without a timezone, you can first treat it as a specific timezone using CAST or CONVERT, then apply the AT TIME ZONE clause.

Can you show me an example query?

Sure! Here's an example: SELECT YourDateTimeColumn AT TIME ZONE 'UTC' AS UTC_Time, YourDateTimeColumn AT TIME ZONE 'Pacific Standard Time' AS PST_Time FROM YourTable;

Are there any functions for other SQL databases?

Yes, other databases like PostgreSQL use AT TIME ZONE as well, while MySQL has CONVERT_TZ(). Each has its own syntax.