Date Format dd/mm/yyyy in mysql

[fahiemulleh]

Hi all. I am developing application using vs2005 and mysql5.0. The problem is I want to store date as dd/mm/yyyy which mysql doesn't allow me to store. Please suggest a way how to do that? I will be very thankful to you.

[led mike]

fahiemulleh wrote:

mysql doesn't allow me to store

Databases store dates in binary form. What you refer to is the output or display or "formatting" of the date after you obtain the date information from the database.

led mike

[Rob Graham]

I think you are confusing the display format and the storage format. Most databases store datetime as a numeric value, tipically milliseconds since some starting date/time. How that date gets formatted for display is up to your UI code. if your locale settings are not appropriate for the dd/mm/yyyy display format, it likely can't reliably covert that string to a datetime. Since you are using ADO.Net, you should just use a parameterized insert/update query, and provide the date as a DateTime value, rather than a string. If you want to accept that format from your UI , just specify an appropriate IFormatProvider and DateTimeStyle to the DateTime.Parse method.

[fahiemulleh]

so Please tell me How to format date (for display) as dd/mm/yyyy.

[led mike]

fahiemulleh wrote:

so Please tell me How to format date

They hide that information in the documentation[^] :rolleyes:

led mike