Re: Re: [PEPr] Proposal for Database::DB_Table
| From: | Paul M Jones | Date: | Wed, 07 Jan 2004 15:57:01 +0000 |
| Subject: | Re: Re: [PEPr] Proposal for Database::DB_Table | ||
| References: | 1 2 3 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-24854@lists.php.net to get a copy of this message | ||
On Jan 7, 2004, at 9:46 AM, Daniel Convissor wrote:
On Wed, Jan 07, 2004 at 11:32:55PM +0800, Alan Knowles wrote:Also, DB_Table defines a DATE as a 10-byte string in ISO format. Similarly, it defines TIME as a 9-byte string in ISO format. This "forced storage" is one of the main conceits of DB_Table; i.e., that you can "force" an RDBMS to store date and time data in ISO format regardless of the native RDBMS format. -- Paul M. Jones pmjones@ciaweb.net Savant: the simple alternative to Smarty. http://phpsavant.com/- think about timestamp (which is not very portable),Perhaps this will help: http://www.analysisandsolutions.com/code/dates.htm It's an overview of several DBMS's and how to get them to handle the standard ISO date and timestamp formats for input and output.