Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mysql datetime with timezone offset

INSERT INTO table_name  CONVERT_TZ(SUBSTR('2011-10-04 12:58:36 -0600',1,19),'+00:00',SUBSTR('2011-10-04 12:58:36 -0600',20));
Comment

PREVIOUS NEXT
Code Example
Sql :: allow null in psql 
Sql :: SQL: get date difference in minutes 
Sql :: change data type in mysql 
Sql :: How do I insert a blob in SQL? 
Sql :: role "postgres" does not exist 
Sql :: sql query rename table 
Sql :: mysql select count 
Sql :: sql select min row 
Sql :: mysql: command not found 
Sql :: update foreign key value in mysql 
Sql :: create table as select * from table mssql 
Sql :: if mysql 
Sql :: open postgresql.conf 
Sql :: df to sql pandas sql achemy 
Sql :: find all tables with column name 
Sql :: sql get first letter of string 
Sql :: postgresql default value 
Sql :: sql delete duplicate rows 
Sql :: to_date postgresql 
Sql :: postgres data location 
Sql :: multiple count with where clause sql 
Sql :: oracle last modification in table 
Sql :: sql select non unique 
Sql :: order by ip address sql 
Sql :: mysql for windows 10 64 bit 
Sql :: run docker container with database as rds metabase 
Sql :: temp tables in sql server 
Sql :: mysql find db contarint 
Sql :: sql insert values into table 
Sql :: bigquery timestamp 
ADD CONTENT
Topic
Content
Source link
Name
6+7 =