SQL SERVER DATETIME FORMAT

by

The default date format depends on the language setting for the database server. You can also change it per session, like:

set language french
select cast(getdate() as varchar(50))
-->
févr 8 2013 9:45AM

More Related Contents:

  1. Convert text to system date format [duplicate]
  2. How to return only the Date from a SQL Server DateTime datatype
  3. Best approach to remove time part of datetime in SQL Server
  4. DateTime2 vs DateTime in SQL Server
  5. SQL query to select dates between two dates
  6. How to combine date from one field with time from another field – MS SQL Server
  7. How can I select the first day of a month in SQL?
  8. How can I convert bigint (UNIX timestamp) to datetime in SQL Server?
  9. How to convert DateTime to VarChar
  10. Get day of week in SQL Server 2005/2008
  11. T-SQL: Round to nearest 15 minute interval
  12. SQL Server Convert Varchar to Datetime
  13. How Can I use “Date” Datatype in sql server?
  14. How to determine the number of days in a month in SQL Server?
  15. Calculate business hours between two dates
  16. SQL Server convert string to datetime
  17. How do I query for all dates greater than a certain date in SQL Server?
  18. A way to extract from a DateTime value data without seconds
  19. How can I compare time in SQL Server?
  20. Difference of two date time in sql server
  21. Custom Date/Time formatting in SQL Server
  22. How to compare datetime with only date in SQL Server
  23. Getting Dates between a range of dates
  24. How can I convert a Sql Server 2008 DateTimeOffset to a DateTime
  25. What is the internal representation of datetime in sql server?
  26. How to get a particular preceding value of a column in SQL [closed]
  27. SQL update from one Table to another based on a ID match
  28. Check if a row exists, otherwise insert
  29. Generating dates between two dates
  30. The most elegant way to generate permutations in SQL server

Leave a Comment