Ng Hwee Hwee [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi all,
can someone kindly point me to a resource that converts all kinds of
possible date inputs into MySQL format of -MM-DD?
example of formats to be converted includes:
d/m/yy
d/m/
d/mm/yy
d/mm/yyy
dd/mm/yy
You might want to look into date conversion on the MySQL side:
http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
Look for
DATE_FORMAT(date,format)
Paul
On Wed, 18 Aug 2004 10:16:59 +0200, Torsten Roehr [EMAIL PROTECTED] wrote:
Ng Hwee Hwee [EMAIL PROTECTED] wrote in message