note 11377 deleted from ref.datetime by vincent
| From: | vincent@php.net | Date: | Thu, 11 Sep 2003 11:53:12 +0000 |
| Subject: | note 11377 deleted from ref.datetime by vincent | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-56076@lists.php.net to get a copy of this message | ||
Note Submitter: shinelight@excite.com
----
To use dates and times in ODBC-compliant databases (including MySQL), you can use the timestamp
format: {ts 'yyyy-mm-dd hh:mm:ss'}. {ts '1899-12-30 00:00:00'} is the earliest
date and time that can be inserted into a database using this format. This is perhaps the most
portable and supported syntax out there by most databases (however, a good database will support
several methods for date/time objects).