How Can I use “Date” Datatype in sql server?

by

You do not have a problem with the “last two”.

However, you do have a problem with all of them, but one point after the other.

Literal dates are dependent on your system’s culture

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

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-

universal format

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

ODBC-format

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

ISO 8601

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

More Related Contents:

  1. Is it possible to use greater than equal to operator in group by? [closed]
  2. Solutions for INSERT OR UPDATE on SQL Server
  3. SQL query to select dates between two dates
  4. How can I select the first day of a month in SQL?
  5. How can I convert bigint (UNIX timestamp) to datetime in SQL Server?
  6. Querying data by joining two tables in two database on different servers
  7. SQL Server Convert Varchar to Datetime
  8. How to replace a string in a SQL Server Table Column
  9. What is the difference between using a cross join and putting a comma between the two tables?
  10. Pivot Table and Concatenate Columns
  11. SQL server query to get the list of columns in a table along with Data types, NOT NULL, and PRIMARY KEY constraints
  12. Calculate business hours between two dates
  13. Correct use of transactions in SQL Server
  14. How to run a stored procedure in sql server every hour?
  15. Composite Primary key vs additional “ID” column?
  16. Why do you create a View in a database?
  17. Logging ALL Queries on a SQL Server 2008 Express Database?
  18. A way to extract from a DateTime value data without seconds
  19. The backend version is not supported to design database diagrams or tables
  20. Difference of two date time in sql server
  21. How to check which locks are held on a table
  22. Custom Date/Time formatting in SQL Server
  23. How to compare datetime with only date in SQL Server
  24. How can I convert a Sql Server 2008 DateTimeOffset to a DateTime
  25. How do I create and query linked database servers in SQL Server?
  26. What is the internal representation of datetime in sql server?
  27. What does ON [PRIMARY] mean?
  28. How do I list all the columns in a table?
  29. The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions
  30. SQL SERVER DATETIME FORMAT

Leave a Comment