Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z

Create table yourtable(
   id INT primary key AUTO_INCREMENT,
   start varchar(50)
);

INSERT INTO yourtable(start) VALUES('1901-02-03T05:30:00.000Z');

UPDATE yourtable
SET start = DATE_FORMAT(STR_TO_DATE(start,'%Y-%m-%dT%H:%i:%s.000Z'),'%Y-%m-%d %H:%i:%s');
Comment

PREVIOUS NEXT
Code Example
Sql :: default column value in sql same as other column 
Sql :: formatting code with SQL Developer 
Sql :: sql trigger difference between for and after 
Sql :: postgres multiple left join causing duplicates jsonb_agg 
Sql :: create sql table from script inline primary key constraint 
Sql :: Windows internal database connection 
Sql :: list enums sql 
Sql :: mysql use password error 
Sql :: plus or add balance in postgresql sql 
Sql :: express api ith mysql data 
Sql :: product of a column in mysql 
Sql :: error-expression-select-list-not-group-by-nonaggregated-column/ 
Sql :: How can INSERT INTO a table 300 times within a loop in SQL? 
Sql :: Stack conditions in CASE statement in PL/SQL 
Sql :: convert databse to achieve log mode oracle 
Sql :: how to remove quotes from a string in ssis load file 
Sql :: missing index on mssql rds database 
Sql :: SQL Combining Multiple Operators 
Sql :: heroku postgres permission denied 
Sql :: 165001709 
Sql :: how to run sql script in postgresql in windows 
Sql :: mysql export data with a where clause 
Sql :: default order by in mysql 
Sql :: liquibase create table example 
Sql :: import sheets doc into databricks 
Sql :: Show mysql account privilleges 
Sql :: how to add mysql to path on termin after installation 
Sql :: como hacer una consulta de un registro que no esta en una tabla en mysql 
Sql :: get who is hired in january in sql 
Sql :: add column in sql server ubuntu 
ADD CONTENT
Topic
Content
Source link
Name
4+7 =