year, month, day of current date

[sand133]

Hi, does anyone know how I can achieve the following in c# as a string...

(1) The current year
(2) The current month
(3) The current Day

in the following format

20080422

im having problem with the 04 bit, DateTime.Now.Month.ToString() returns 4 not 04.

thanks

 

[earthandfire]

[tt]DateTime.Now.Month.ToString("00")[/tt]


Hope this helps.

 

[sand133]

thank you brother

 

[sand133]

does anyone know how do it in SQL, thanks

 

[jmeckley]

forum 183, or to stress the gray matter use Sql BOL <F1> from QA and

http://www.google.com/search?q=tsql+datetime+functions

Jason Meckley
Programmer
Specialty Bakers, Inc.