How to Correctly Insert DateTime Values into SQL Server Tables?

SQL Query to Insert a Datetime Value in SQL Server

Inserting a datetime value into an SQL Server table using the SQL query can be tricky due to syntax requirements. When using a simple date and time format like "18-06-12 10:34:09 AM," you may encounter errors.

Error with Quotes:

If you enclose the datetime value in single quotes, you get the error "Cannot convert varchar to datetime." This is because SQL Server interprets it as a string rather than a datetime.

Solution:

To insert a datetime value correctly, use the YYYYMMDD format for unambiguous date determination.

insert into table1(approvaldate)values('20120618 10:34:09 AM');

Alternative Method:

If you prefer the dd-mm-yy hh:mm:ss xm format, you need to use the CONVERT function with the appropriate style.

insert into table1 (approvaldate)
       values (convert(datetime,'18-06-12 10:34:09 PM',5));

In this case, "5" represents the style for Italian dates (dd/mm/yy hh:mm:ss PM).

The above is the detailed content of How to Correctly Insert DateTime Values into SQL Server Tables?. For more information, please follow other related articles on the PHP Chinese website!