SQL Select Date

Question

I am trying to select a date out of SQL and get it into a format that looks like MMDDYYYY.  For example, todays date would be 12122012.  Any ideas on how to do this?

Thanks in advance!!

---

http://www.isolutionspartners.com/

Answer 1

Select Replace(Convert(varchar(10), GetDate(), 101), '/', '')

Tom

Answer 2

Try this,

SELECT replace(convert(varchar, getdate(), 101), '/', '')

---

Muhammad Azeem

Answer 3

If you are using SQL Server 2012. It is much more simpler:

SELECT FORMAT(getdate(), 'MMddyyyy')

---

Please mark as answer if this answers your question. Please mark as helpful if you found this post was helpful.