How to convert UTC time to PST?

Question

My table has date column in UTC time zone. I want to convert the data into PST. How to do this?

UTC time:

Fathah Rehman P · Accepted Answer

For table test_table with column date_column containing datetime, to get local time from UTC you can use:

SELECT datetime(date_column,'localtime') as local_time from test_table;

Example with IST (UTC is 5 hours and 30 minutes behind of IST):

SELECT datetime(date_column||"-05:30") as local_time from test_table;

Donate For Us