RE: [PHP-DB] MySQL Timestamp
| From: | Jeff Oien | Date: | Wed, 18 Jul 2001 18:36:14 +0000 |
| Subject: | RE: [PHP-DB] MySQL Timestamp | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-10557@lists.php.net to get a copy of this message | ||
Thanks. I was using MySQL by DuBois book as a reference.
Jeff
> According to the manual, 12 is YYMMDDHHMMSS and 14 is YYYYMMDDHHMMSS.
>
>
> http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#DATETIME
>
>
> "Jeff Oien" <jeff@webdesigns1.com> wrote:
> I have a field that's timestamp(12) which should be YYYYMMDDhhmm
> but what I'm getting is
> 010718125000
>
> what I was expecting was
> 200107181250
>
> How can I get what I was expecting? Thanks.
> Jeff Oien
>
>