Search
 
SCRIPT & CODE EXAMPLE
 

SQL

current setting postgres timezone

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

postgres set timezone

SET TIME ZONE 'Europe/Moscow';
Comment

postgresql date at timezone

select updatedat AT TIME ZONE 'UTC';
Comment

storing timezones in postgres

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

PREVIOUS NEXT
Code Example
Sql :: postgresql reset auto_increment index 
Sql :: sqlite3 how to get column names of a table 
Sql :: t-sql find object by name 
Sql :: psql restore from tar 
Sql :: postgres killing connections on db 
Sql :: invalid reference to FROM-clause entry for table "unidades 
Sql :: sqlite create integer column with limit 
Sql :: psql autocomplete for mac brew install 
Sql :: mysql id of inserted row 
Sql :: postgres get timestamp 
Sql :: postgresql show current database 
Sql :: oracle export trigger ddl 
Sql :: load mysql dumb 
Sql :: hibernate with springboot mysql 
Sql :: psql human readable 
Sql :: mysql month name extract 
Sql :: sql list users and roles 
Sql :: postgres get database encoding 
Sql :: user privileges postgresql information_schema 
Sql :: oracle user quota on tablespace 
Sql :: sql server count all tables rows 
Sql :: mysql search like order by best match 
Sql :: What is localhost IP and MySql default port no. 
Sql :: postgresql list columns 
Sql :: mysql delete 
Sql :: mysql root localhost run 
Sql :: create table sql 
Sql :: mysql remove user privileges 
Sql :: mysql tables max count 
Sql :: mysql alter decimal precision 
ADD CONTENT
Topic
Content
Source link
Name
1+5 =