Re: MDB & postgresql timestamptz
| From: | Jeroen Houben | Date: | Mon, 16 Jun 2003 11:13:39 +0000 |
| Subject: | Re: MDB & postgresql timestamptz | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-5993@lists.php.net to get a copy of this message | ||
Lukas Smith wrote:
Thanks, JeroenFrom: Jeroen Houben [mailto:jeroen@terena.nl] Sent: Monday, June 16, 2003 12:54 PMInserting like this won't work on a normal timestamp field... $db->getTimestampValue(mktime())well the problem there is that you are not using the MDB Timestamp format. http://www.backendmedia.com/MDB/docs/datatypes.html OKay, so I should not pass real timestamps to the query, but generate a YYYY-MM-DD HH:MI:SS formatted date myself, or with the help of some Date package.