Prev: Replacing accented characters?
Next: Including file from a registered shutown function on a syntax parse error
From: Haig Davis on 27 Jan 2010 17:58
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
From: Floyd Resler on 27 Jan 2010 18:05
Haig,
What kind of problems are you having? I do this by using the date function to convert to the YYYY-MM-DD format for MySQL. I've had no problems with birth dates prior to 1970.

Take care,
Floyd

On Jan 27, 2010, at 5:58 PM, Haig Davis 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

From: Jonathan Tapicer on 27 Jan 2010 18:38
On Wed, Jan 27, 2010 at 7:58 PM, Haig Davis <level510(a)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
From: Ashley Sheridan on 27 Jan 2010 18:39
On Wed, 2010-01-27 at 20:38 -0300, Jonathan Tapicer wrote:

> On Wed, Jan 27, 2010 at 7:58 PM, Haig Davis <level510(a)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


 | 
Pages: 1
Prev: Replacing accented characters?
Next: Including file from a registered shutown function on a syntax parse error