/SQL/Current setting postgres timezone

Current setting postgres timezone

Postgres set timezone

SET TIME ZONE 'Europe/Moscow';

2

Postgresql date at timezone

select updatedat AT TIME ZONE 'UTC';

0

Current setting postgres timezone

SELECT * FROM pg_timezone_names WHERE name = current_setting('TIMEZONE');

0

Similar codes

0 vote201 views2 answers
Script all indexes in a database
SQL
0 vote227 views1 answer
Executescalar in sql server
SQL
17 votes223 views5 answers
Order by sql
SQL
0 vote191 views1 answer
Psql select * from table
SQL
0 vote211 views1 answer
Sp in sql server
SQL
0 vote200 views1 answer
Allow external access to mysql
SQL
10 votes192 views1 answer
Create table oracle
SQL
0 vote200 views1 answer
Postgres week number
SQL
1 vote215 views1 answer
STOP message of how many rows affected sql
SQL
0 vote200 views1 answer
Doesn't have default value mysql
SQL

Share