Re: Storing time in mysql prior to 1970

On Wed, 2010-01-27 at 20:38 -0300, Jonathan Tapicer wrote: > 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 > I think you may be hitting PHP's data limitations here, rather than MySQL's. If that is the case, have a look at Pear Date, which allows you to specify dates and times on 32-bit systems that go outside of PHP's normal range. Thanks, Ash http://www.ashleysheridan.co.uk