/SQL/Storing timezones in postgres

Storing timezones in postgres

Postgres set timezone

SET TIME ZONE 'Europe/Moscow';

2

Storing timezones in postgres

select name from pg_timezone_names where name not like 'posix%' and name not ilike 'system%' order by name;

0

Source: magistratehq.com

Similar codes

0 vote221 views1 answer
Formatting code with SQL Developer
SQL
0 vote215 views1 answer
How to access to mysql without root
SQL
0 vote222 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL
0 vote221 views1 answer
Dnsmasq.conf location macos
SQL
1 vote231 views1 answer
Oracle sql average
SQL
0 vote245 views1 answer
SQL column name Oracle
SQL
0 vote256 views1 answer
Min:sec datediff mssql
SQL
0 vote215 views1 answer
IIF
SQL
15 votes235 views3 answers
Postgresql change column type
SQL
0 vote246 views1 answer
What logs are available on RDS MySQL?
SQL

Share