 |
 |
Find a programming school near you
php-db | 2001062
Date: 06/21/01
- Next message: Russ Michell: "Re: [PHP-DB] flush privileges"
- Previous message: DanielW: "[PHP-DB] concatenation"
- Maybe in reply to: Rosen: "[PHP-DB] Date field"
- Next in thread: Russ Michell: "Re: [PHP-DB] Date field"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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 <email protected>>
To: php-db <email protected> <php-db <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: php-db-unsubscribe <email protected>
>For additional commands, e-mail: php-db-help <email protected>
>To contact the list administrators, e-mail: php-list-admin <email protected>
>
>
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe <email protected> For additional commands, e-mail: php-db-help <email protected> To contact the list administrators, e-mail: php-list-admin <email protected>
- Next message: Russ Michell: "Re: [PHP-DB] flush privileges"
- Previous message: DanielW: "[PHP-DB] concatenation"
- Maybe in reply to: Rosen: "[PHP-DB] Date field"
- Next in thread: Russ Michell: "Re: [PHP-DB] Date field"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
