Convert text to system date format [duplicate]

by

EDIT

From SQL Server 2012 and later you might use the FORMAT function if you want to force a date into a formatted text: https://msdn.microsoft.com/en-us/library/hh213505.aspx

With earlier versions you might use something like this:

DECLARE @d DATETIME=GETDATE();

DECLARE @TargetFormat VARCHAR(100)='DD/MM/YYYY';

SELECT CONVERT(VARCHAR(100),@d, CASE @TargetFormat
                                  WHEN 'MM/DD/YYYY' THEN 101
                                  WHEN 'DD/MM/YYYY' THEN 103
                                  --add all formats convert can undertsand
                                 ELSE 101 END )

Previous

Look here: https://msdn.microsoft.com/en-us/library/ms187928.aspx

The third parameter in CONVERT specifies the format.

The MM/DD/YYYY was 101, dd/mm/yyyy was 103

But: You should avoid date literals as they are depending on your system’s culture.

From your question I get that you are the owner of the source, so you can change this to the way you need it. I strongly advise you to use independent formats.

Look here: https://stackoverflow.com/a/34275965/5089204

More Related Contents:

  1. How to return only the Date from a SQL Server DateTime datatype
  2. Best approach to remove time part of datetime in SQL Server
  3. DateTime2 vs DateTime in SQL Server
  4. SQL query to select dates between two dates
  5. How can I select the first day of a month in SQL?
  6. How can I convert bigint (UNIX timestamp) to datetime in SQL Server?
  7. How to compare datetime with only date in SQL Server
  8. Getting Dates between a range of dates
  9. I dont know sql syntax for my table [closed]
  10. How do you list the primary key of a SQL Server table?
  11. Calculating distance between two points (Latitude, Longitude)
  12. Add Foreign Key relationship between two Databases
  13. SQL Server check case-sensitivity?
  14. How to update Identity Column in SQL Server?
  15. How to assign an exec result to a sql variable?
  16. Concatenate values based on ID
  17. SQL: parse the first, middle and last name from a fullname field
  18. varbinary to string on SQL Server
  19. Scope of temporary tables in SQL Server
  20. SQL Server 2005 ROW_NUMBER() without ORDER BY
  21. Can an INNER JOIN offer better performance than EXISTS
  22. Find the real column name of an alias used in a view?
  23. Stored procedure that exports data into csv files only exports to one file
  24. Get Start and End Date from Week Number SQL Server
  25. How to create a pivot query in sql server without aggregate function
  26. SQL take just the numeric values from a varchar
  27. SQL Server FOR XML Path make repeating nodes
  28. SQL – How do I get only the numbers after the decimal?
  29. How to retrieve records for last 30 minutes in MS SQL?
  30. Why do SQL Server Scalar-valued functions get slower?

Leave a Comment