Converting Dates for a mysql database
Posted: Wed Apr 14, 2004 10:37 am
Hi
The system that i am currrently developing has a booking form. On this booing from users will have to enter a bookstart and a bookend. However the MYSQL format for dates is YYYYMMDD. This presents a problem as on this side of the world people use the format DDMMYYYY. So users will be entering dates in that format and this leads to problems with the bookings in the database as they are in the wrong format. Does anyone know of a way in which i could convert the dates into the correct format? The fields bookstart and bookend are type DATE in the database
Thx
Gerry
The system that i am currrently developing has a booking form. On this booing from users will have to enter a bookstart and a bookend. However the MYSQL format for dates is YYYYMMDD. This presents a problem as on this side of the world people use the format DDMMYYYY. So users will be entering dates in that format and this leads to problems with the bookings in the database as they are in the wrong format. Does anyone know of a way in which i could convert the dates into the correct format? The fields bookstart and bookend are type DATE in the database
Thx
Gerry