/SQL/Mysql datetime with timezone offset

Mysql datetime with timezone offset

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));

1

Source: stackoverflow.com

Similar codes

0 vote109 views1 answer
Postgres type equivalent to timespan c#
SQL
11 votes101 views2 answers
Having clause
SQL
3 votes125 views3 answers
Restart mysql mac
SQL
0 vote128 views1 answer
How convert into in in sql query
SQL
0 vote135 views1 answer
Sql date time query find
SQL
1 vote112 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote111 views1 answer
Enable full text search mysql
SQL
0 vote109 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
0 vote111 views1 answer
Mysql récupérer le code création de vue
SQL
0 vote109 views1 answer
SQL Server rename foreign key constraint
SQL

Share