You can get the date in the required format from the database. Try this

SELECT CONVERT(VARCHAR,GETDATE(),106)

modified on Friday, April 30, 2010 3:34 AM