Re: Date field
| From: | Dobromir Velev | Date: | Thu, 21 Jun 2001 07:39:16 +0000 |
| Subject: | Re: Date field | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-9681@lists.php.net to get a copy of this message | ||
Hi,
it depends on the the MySQL date type you are using.
Here are the formats for the different types.
DATE - 'YYYY-MM-DD'
DATETIME - 'YYYY-MM-DD HH:MM:SS'
TIMESTAMP(14) - YYYYMMDDHHMMSS
TIMESTAMP(12) - YYMMDDHHMMSS
TIMESTAMP(8) - YYYYMMDD
TIMESTAMP(6) - YYMMDD
TIME - 'HH:MM:SS'
YEAR(4) - YYYY
YEAR(2) - YYYY you can use 'YY' here if you use years between
1970 and 2069
Dobromir Velev
-----Original Message-----
From: Rosen <rosen_dm@dir.bg>
To: php-db@lists.php.net <php-db@lists.php.net>
Date: Wednesday, June 20, 2001 10:57 PM
Subject: [PHP-DB] Date field
>Hi,
>Can someone tell me how do stote date field in MySQL DB ?
>
>Thanks,
>Rosen M.
>
>
>
>
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
>For additional commands, e-mail: php-db-help@lists.php.net
>To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>