Re: Storing time in mysql prior to 1970
| From: | Jonathan Tapicer | Date: | Wed, 27 Jan 2010 23:38:56 +0000 |
| Subject: | Re: Storing time in mysql prior to 1970 | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-301581@lists.php.net to get a copy of this message | ||
On Wed, Jan 27, 2010 at 7:58 PM, Haig Davis <level510@gmail.com> wrote:
> Hi Everyone,
>
> I'm sure I'm missing something simple. I'm trying to store dates of birth
> prior to 1970 in mysql. I've tried mysql's date_format but am hitting a
> wall. I'm chasing my tail and was hoping for the best practice.
>
> Many Thanks
>
> Haig
>
Use the types date or datetime instead of timestamp, read more about
it here: http://dev.mysql.com/doc/refman/5.1/en/datetime.html