Date formats in SQL Server Stored Procedures
This one will be easy, I'm sure. I'm a novice at Stored Procedures, and I'm wondering what function I can use to display a smalldatetime field (currently displaying as Dec 19, 2008 12:00AM) as a short date (12/19/2008)?
I am on Sql Server...
I am on Sql Server...
ASKED:
Nov 11, 2008 9:18 PM GMT
UPDATED:
November 11, 2008 9:37:55 PM GMT
RELATED QUESTIONS
- SQL Server date format
- How to create date in SQL Server 2000
- Create Excel file on web server by using SQL
- What Is Your SQL Server 2008 Adoption Rate?
- Stored procedures in SSRS
- How can I take a backup of a SQL Server stored procedure only?
- Is it possible using Embedded SQL or something else in RPG to directly update and MS SQL DB
- Service Broker downside
- In SQL Server 2005, how do I display all permissions a user/login has? Is there a stored procedure to do this?
- Create a database in SQL Server 2005
Answer Wiki:
You could use the CONVERT function.
CONVERT ( data_type [ ( length ) ] , expression [ , style ] )
For example:
Have a look at the CAST and CONVERT MSDN Page to see the available styles table, and to get more help.
CONVERT ( data_type [ ( length ) ] , expression [ , style ] )
For example:
select convert(varchar,DateColumn,101) from table_x
Have a look at the CAST and CONVERT MSDN Page to see the available styles table, and to get more help.
60,245 pts.
To see other answers submitted to the Answer Wiki View Answer History.
