CirquedeSQLeil (12/21/2009)

---

I'm curious what the need is to convert a date to a Number. I would leave the date as one of the datetime datatype in sql 2005.


Now to get the Date Format you seek, you will need to convert to varchar and check the following: http://www.sqlusa.com/bestpractices2005/centurydateformat/

Lynn Pettis (12/21/2009)

---

Actually, on the SQL side dropping the time portion off getdate is this simple:

dateadd(dd, datediff(dd, 0, getdate()), 0)

CirquedeSQLeil (12/21/2009)

---

Noted and added to my toolbox - I had never used that method. Thanks Lynn.

rahulsony111 (12/21/2009)

---

I am trying this from 5 hrs and unable to get a solution.

In target table i have that column as numeric.
I tried getdate() with datatype databasedate but it is returning 2009-12-21. So that value is not going into target table sand saying it as invalid number.

I want it ti look like 20091221, only then it goes into targat table