SQL Server Transact Basic to Expert - Display Current date in mm/dd/yyyy format
SQL Server Transact Basic to Expert - Display Current date in mm/dd/yyyy format
This blog shows how to display the current dae in mm/dd/yyyy using SQL query
Example:
SELECT CONVERT(varchar(20), GETDATE(), 101)
The expected result would be 06/16/2011