date format (mm/dd/yyyy)

[Vasudha Balyan]

I am using system.datetime.today to get today's date. I want to send this value to a date field in sql server in the mm/dd/yyyy format, but it is sending the date in mm/d/yyyy format. It's not sending trailing zero for a single digit day. For example; if today's date is 12/08/2009, it is giving me 12/8/2009 instead of 12/08/2009. Please advise how can I accomplish this.

Thanks

[tlhintoq]

It would help if we saw the code you are using to format the date to your needs.
You should be able to use the .ToString() method to format as needed.

myDateTimeObject.ToString("MM/dd/yyyy")

;

[Vasudha Balyan]

I am actually storing this value in date type variable, so can't use .tosring("mm/dd/yyyy"). I am planning to store this value in string variable now.
Thanks

[Vasudha Balyan]

Hello tlhintoq
Actually, when I send this value to sql serverdatabase, then it gets converted to 12/8/2009 from 12/08/2009. Im using the following code:
cmd.Parameters.Add("@MailOptOutDate", SqlDbType.VarChar).Value = ((System.DateTime.Today).AddDays(-10)).ToString("MM/dd/yyyy");
Thanks

[Plater]

Hmmm a DateTime(or date) field has NO specific format. How you display it is up to you.

[Vasudha Balyan]

I have figured it out myself. I was having trouble when I was trying to retrieve the date from the database & display it in mmddyyyy format in a fixed length file as we can not use format on date variables. I used the cast & was able to display it in correct format.