/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 vote178 views1 answer
Mysql group rows with same value
SQL
0 vote198 views1 answer
Mysql command prompt date insert format
SQL
5 votes193 views3 answers
Sql make column nullable
SQL
0 vote320 views3 answers
Osx stop mysql service
SQL
0 vote189 views1 answer
Compare subqueries oracle
SQL
0 vote301 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
0 vote145 views1 answer
Mysql convert column to uppercase
SQL
10 votes186 views1 answer
Oracle view dependencies
SQL
13 votes145 views2 answers
Oracle all source
SQL
42 votes268 views6 answers
Install beautifulsoup
SQL

Share