Date format

[strings]

I am using Mysql as my database. i insert the date in the format DateTime.Now.ToString("dd/MM/yyyy") but the strange thing is its gets entered in dd-MM-yyyy format. EVen if i manaually entered the date in database in dd/MM/yyyy and retrive the value from database , its get the format as dd-MM-yyyy. where is the prob???

[Ashfield]

There is no problem. Databases don't store the date in a specific format - Don't know about MySql, but SQL Server and Sybase store it as a number, its up to your code to display it how you want. There will be a default format from the database (usually defined at server level) and its up to you to format it how you want.

Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

[Lost User]

http://www.plus2net.com/sql_tutorial/date-inserting.php[^]

[strings]

Thks for ur reply, but it didn't solved my prob. Interesting thing is date format dd/MM/yyyy in getting inserted correctly on my PC. but when i deployed at client location its gets entered as dd-MM-yyyy format coloum Type is varchar 50.

[Lost User]

I think it's a localization problem. Save the date in MySql Date format, not in string.

[Tom Deketelaere]

strings wrote:

coloum Type is varchar 50

There is your problem

strings wrote:

date format dd/MM/yyyy in getting inserted correctly on my PC. but when i deployed at client location its gets entered as dd-MM-yyyy format

When displaying a date (and inserting it into db in a varchar column) without specific formating it will display the way the date settings are set in Windows. First of all you should use a date column type. Then you can either instruct your client on how to change his OS settings (not recommended) or do a format of the date.

[Ashfield]

strings wrote:

coloum Type is varchar 50.

If you had said that in the first place it would have been obvious, its a localisation issue nothing to do with sql. Use a proper datatype and your problem will be solved.

Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP