Format Date function? 1

[Mongr1l]

Is there a function in sql that formats the date?

I'm trying to convert the dates in my table from 'DD-MMM-YYYY' to 'MMDDYY'.

Please tell me there's a simple way to do this.

mongr1l

 

[SQLDenis]

select convert(varchar(10),getdate(),101)

no slashes?
select replace(convert(varchar(10),getdate(),101),'/','')

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[Mongr1l]

Thanks, Denis.