Date Format as dd/mm/yyyy

[fahiemulleh]

Hi all, I am stuck with problem while using mysql5.0. I am using it with visualstudio2005. It doesn't allow me to store date as dd/mm/yyyy. I need to store it in this format. Kindly suggest me How it will be done? Thanks for your consideration.

[Rob Graham]

I answered this in the C# forum where you cross-posted. Posting the same question to multiple forums is generally regarded as rude.

[Eric Dahlvang]

It depends upon what libraries you are using to connect to MySQL. But, for the most part, you need to know that when you save your date you need to format it yyyy-mm-dd. See Handling Date and Time Information in Connector/NET[^] MySQL and the .NET languages handle date and time information differently, with MySQL allowing dates that cannot be represented by a .NET data type, such as '0000-00-00 00:00:00'. These differences can cause problems if not properly handled.

--EricDV Sig--------- Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them. - Laurence J. Peters

[Colin Angus Mackay]

I don't know MySQL but as a general rule databases should not be culture specific. That is the job of the GUI for your application. If MySQL supports it you should use the ISO date format yyyy-mm-dd as it is culture neutral. When you retrieve data from the database you can then format it for the culture it is to be used in. Or, when you save data to the database it should be stored in a culture neutral format.

---

Upcoming Scottish Developers events: * UK Security Evangelists On Tour (2nd November, Edinburgh) * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog