sql server convert date to string MM/DD/YYYY

by

That task should be done by the next layer up in your software stack. SQL is a data repository, not a presentation system

You can do it with

CONVERT(VARCHAR(10), fmdate(), 101)

But you shouldn’t

More Related Contents:

  1. Deleting duplicate record in SQL Server
  2. Optional multi-valued parameters in SSRS
  3. Could not load file or assembly Microsoft.SqlServer.management.sdk.sfc version 11.0.0.0
  4. Send e-mail from a trigger
  5. Create a view with ORDER BY clause
  6. How to run the same query on all the databases on an instance?
  7. T-SQL split string based on delimiter
  8. SQL Update with row_number()
  9. CREATE TABLE IF NOT EXISTS equivalent in SQL Server [duplicate]
  10. How to write UTF-8 characters using bulk insert in SQL Server?
  11. Is a single SQL Server statement atomic and consistent?
  12. Cannot use UPDATE with OUTPUT clause when a trigger is on the table
  13. CASE WHEN statement for ORDER BY clause
  14. How to get last 7 days data from current datetime to last 7 days in sql server
  15. determining the character set of a table / database?
  16. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  17. How to query for Xml values and attributes from table in SQL Server?
  18. Reference an alias elsewhere in the SELECT list
  19. Reporting Services permissions on SQL Server R2 SSRS
  20. How to pass string parameter with `IN` operator in stored procedure SQL Server 2008
  21. Count Returning blank instead of 0
  22. How to Split String by Character into Separate Columns in SQL Server
  23. Compute MD5 hash of a UTF8 string
  24. Error: Failed to generate a user instance of SQL Server
  25. Passing dynamic order by in stored procedure
  26. How do I find the data directory for a SQL Server instance?
  27. replace NULL values with latest non-NULL value in resultset series (SQL Server 2008 R2)
  28. How to concatenate all columns in a select with SQL Server
  29. T-SQL calculate moving average
  30. How to automatically generate unique id in SQL like UID12345678?

Leave a Comment