Re: [PHP-DB] date problem in MySQL DB

2004-01-13 Thread Justin Patrin
Brett King wrote: Hi Angelo Yes you will have to reformat and he is something that may help you. Hope it does function dateCheckMysql ($date) { list($dateDay, $dateMonth, $dateYear) = explode("/", $date); if ((is_numeric($dateDay)) && (is_numeric($dateMonth)) &&

RE: [PHP-DB] date problem in MySQL DB

2004-01-13 Thread brett king
Hi Angelo Yes you will have to reformat and he is something that may help you. Hope it does function dateCheckMysql ($date) { list($dateDay, $dateMonth, $dateYear) = explode("/", $date); if ((is_numeric($dateDay)) && (is_numeric($dateMonth)) && (is_numer

Re: [PHP-DB] date problem in MySQL DB

2004-01-13 Thread CPT John W. Holmes
From: "Angelo Zanetti" <[EMAIL PROTECTED]> > This might be slightly off topic but hopefully someone can help. > I have a field that is a varchar and I stored dates in it. But now I want to > change the type of the column to date, but I have a problem that the formats > differ: > > my format: mm/dd

[PHP-DB] date problem in MySQL DB

2004-01-13 Thread Angelo Zanetti
Hi guys This might be slightly off topic but hopefully someone can help. I have a field that is a varchar and I stored dates in it. But now I want to change the type of the column to date, but I have a problem that the formats differ: my format: mm/dd/ mySQL format: -mm-dd So can I eithe