RE: [PEAR] MDB->getDateValue() problem

> -----Original Message----- > From: Michael Raidel [mailto:raidel@i-one.at] > Sent: Thursday, January 09, 2003 6:21 PM > To: pear-general@lists.php.net > Subject: [PEAR] MDB->getDateValue() problem > > Hi! > > When I use getDateValue() to get a Date-String to insert into the DBMS, > the function returns exactly the same string which I passed to it. It > seems that the function does nothing at all! In fact it seems to me that > it should be overriden by the appropriate function in the > DB-specific-part but it isn't. The manual describes the function as > "Convert a text value into a DBMS specific format that is suitable to > compose query statements.". > > Maybe someone can give me a hint what happened to getDateValue() or what > I'm doing wrong! You are doing nothing wrong at all. The format wasn't chosen arbitrarily, but instead to require changes to the string as seldom as possible. Both MySQL (when using date, time and datetime) and PostGreSQL use the same format as MDB does. So there needs to be no conversion. This may not be the case for other RDBMS however. Regards, Lukas