I have a sort of a calendar, where the user can enter events based on dates. But when i test it the mysql database is always converting the date weird.

If i write -> converted to
20.06.2003 -> 20.06.2020
20.06 -> 01.01.0001
20/06 -> 01.01.0001
20/06/03 -> 03.06.2020

i've tried with field types datetime, date and timestamp, and all give the same weird outputs. Can somebody help me fix it please?

.:. DWMX .:. MS IIS 5.1 .:. WinXP .:. MySQL .:. ASP VB

Edited by - Kr]st[an on 10 Jun 2003 23:29:23

it's probably because there are only 12 months in a year and not 20. It displays dates as month/day/year and not day/month/year.

if so, is there a way to reformat it so that i get

dd.mm.yyyy

thats the way i want it. doesen't matter if clock is there or not because i can trim that away anyhow.

please help me

.:. DWMX .:. MS IIS 5.1 .:. WinXP .:. MySQL .:. ASP VB

Take a look at this link
www.mysql.com/doc/en/Date_and_time_types.html