MySQL中的日期时间数据类型使错误 [英] Datetime datatype in MySQL making error

问题描述

我已经使用下面提到的MySQL查询创建了一个表.

I have created a table using below mensioned query in MySQL.

CREATE TABLE Pat_Visit (PatientID INT(16), FOREIGN KEY(PatientID) REFERENCES patient_demo(PatientID),Visit_DateTime DATETIME,Visit_Title VARCHAR(6),
DoctorID INT(16),FOREIGN KEY(DoctorID) REFERENCES Doctor(DoctorID));

并且我试图使用下面给出的查询来添加一些数据.

and i have tried to add some data using query given below.

  INSERT INTO Pat_Visit(PatientID,Visit_DateTime,Visit_Title,DoctorID) VALUES (100001,10/24/11 10:00 AM,'PAIN IN JOINTS',920001);

但是它ios抛出错误.我不知道这是什么问题.有人可以帮我吗...

but it ios throwing error. I dont know what is the problem here.can anybody help me please...

推荐答案

尝试以下说明:

INSERT INTO Pat_Visit(PatientID,Visit_DateTime,Visit_Title,DoctorID) 
VALUES (100001,'2011-10-24 10:00:00','PAIN IN JOINTS',920001);

您可以这样转换日期:

STR_TO_DATE('10/24/11 10:00 PM','%m/%d/%Y %h:%i %p')

所以说明是:

INSERT INTO Pat_Visit(PatientID,Visit_DateTime,Visit_Title,DoctorID) 
    VALUES (100001,STR_TO_DATE('10/24/11 10:00 PM','%m/%d/%Y %h:%i %p'),'PAIN IN JOINTS',920001);

从 MySQL日期时间文档中提取

MySQL检索并在'YYYY-MM-DD HH:MM:SS'中显示DATETIME值 格式.支持的范围是'1000-01-01 00:00:00'至'9999-12-31 23:59:59'.

MySQL retrieves and displays DATETIME values in 'YYYY-MM-DD HH:MM:SS' format. The supported range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'.

这篇关于MySQL中的日期时间数据类型使错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！