如何使用“日期”数据类型在sql server？ [英] How Can I use "Date" Datatype in sql server?

问题描述

你好朋友我需要你的帮助，当我试图创建数据类型日期表中的列，它给我错误，我不能添加到这里是我的代码

Hello Friends I need your help please when I'm trying to create column in table with data type "Date" it gives me error and I can't add it here is my code

Create table Orders (
Order_ID INT Primary Key,
Book_name varchar(100) ,
isbn varchar(100) ,
Customer_ID INT Foreign key references Customer,
Order_date date,
);

另一件事情，它需要从我获取的日期之前创建的一个

another thing it requires from me to get date of something which is before created one

更清楚：查询询问指示在8月2日之前查找日期我如何做

to be more clear: the query asked indicates to find date before 2 of August How can I do that

输入数据

Insert Into Orders(Order_ID, Book_name, isbn, Customer_ID, Order_date) values (1, 'Design User Interface',9345678210123, 1, '02-08-2015'); 
Insert Into Orders(Order_ID, Book_name, isbn, Customer_ID, Order_date) values (2, 'Fire',9654693261489, 1, '05-08-2015'); 
Insert Into Orders(Order_ID, Book_name, isbn, Customer_ID, Order_date) values (3, 'The Odyssey',9654864332511, 2, '01-08-2015'); 
Insert Into Orders(Order_ID, Book_name, isbn, Customer_ID, Order_date) values (4, 'Anatomy',9654877777755, 2, '30-07-2015'); 
Insert Into Orders(Order_ID, Book_name, isbn, Customer_ID, Order_date) values (5, 'Surgery',9654864951753, 2, '01-07-2015'); 

但是，它只接受前3个插入，最后两个它给我错误：/

but, it accept only first 3 insertion and last two it gives me error :/

推荐答案

您的后两个没有问题。

您的日期被解释为MM-DD-YYYY。这种完善取决于你的系统的文化。前三个都变成错误的日期，但工作。

Your dates are interpreted as MM-DD-YYYY. This intrepretation is depenent on your system's culture. The first three are turning into wrong dates but work. The 4th breaks and the fifth is never executed (due to the error before).

因此，实际的错误在于第4行。

So the actual error lies on line 4.

每当你处理日期时，使用文化独立格式。最好使用以下其中一种：

Whenever you deal with dates, use culture independent formats. It is better to use either of the following-

20150730 (=> the 30th of July in 2015)

ODBC格式

ODBC-format

{d'2015-07-30'} or {t'23:30:59'} or {ts'2015-07-30 23:30:59'}

ISO 8601

ISO 8601

'2015-07-30T00:00:00'

这篇关于如何使用“日期”数据类型在sql server？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！