Sql Stored Procedure Date time

Aug 27 2012 1:20 AM

in a sql server 2008, if a date time thats coming back is in the format of "12:00 AM 01/01/2012"

1. How do i return or format "01/01/2012" in stored procedure only"?

2. How do i return or format "Jan 1, 2012" in stored procedure only"?

3. How do i return or format "12:00 AM in stored procedure only"?

Answers (4)

sql server