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 <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
