Re: [PHP] Date Handling Recommendations

2005-07-21 Thread JM
thanks all. i just made the changes and its working smooth. i remember having a bunch of drama trying to use DATE data type...oh well, i just needed something to get me off my butt haha thanks again On 7/21/05, Philip Hallstrom <[EMAIL PROTECTED]> wrote: > > Hi all, > > I need to manage some recor

Re: [PHP] Date Handling Recommendations

2005-07-21 Thread Edward Vermillion
Jim Moseby wrote: Hi all, I need to manage some records with dates. mmdd I'm putting select options breaking the three up in numeric pull [snip] For instance, what would you have to do to get the day of the week for a day 66 days prior to the stored date? If your date was stored in a DA

RE: [PHP] Date Handling Recommendations

2005-07-21 Thread Jim Moseby
> > Hi all, > I need to manage some records with dates. mmdd > > I'm putting select options breaking the three up in numeric pull > downs. no problem gathering and storing the data in my mysql db as > integers then posting them for existing records etc. i know their is a > datetime datatype b

Re: [PHP] Date Handling Recommendations

2005-07-21 Thread Philip Hallstrom
Hi all, I need to manage some records with dates. mmdd I'm putting select options breaking the three up in numeric pull downs. no problem gathering and storing the data in my mysql db as integers then posting them for existing records etc. i know their is a datetime datatype but it doesnt see

[PHP] Date Handling Recommendations

2005-07-21 Thread JM
Hi all, I need to manage some records with dates. mmdd I'm putting select options breaking the three up in numeric pull downs. no problem gathering and storing the data in my mysql db as integers then posting them for existing records etc. i know their is a datetime datatype but it doesnt seem

Re: [PHP] Date handling

2004-11-16 Thread Ryan
imestamp. > > You may be able to come up with something clever using strtotime() > however. > http://us2.php.net/manual/en/function.strtotime.php > > -M > > -----Original Message- > From: Ryan [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 16, 2004 9:23 AM > To:

RE: [PHP] Date handling

2004-11-16 Thread Mike
me up with something clever using strtotime() however. http://us2.php.net/manual/en/function.strtotime.php -M -Original Message- From: Ryan [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 16, 2004 9:23 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] Date handling Hi Robert, Storing the date

Re: [PHP] Date handling

2004-11-16 Thread Ryan
Hi Robert, Storing the date in my database isn't the issue I'm running into. The problem I'm having is that if I have a date "1950-01-01", how can I display it in my PHP script as "Jan 1, 1950". Or if I have "2040-04-01", how to get it to display as "Apr 1, 2040". I can't see a way to do tha

Re: [PHP] Date handling

2004-11-16 Thread Robert Sossomon
I'm guessing Red Hat Enterprise or at least the kernel I'm using (which is the latest RH kernel) qualifies under the Linux category above. Also, with the application I'm writing, I need to deal with dates after 2038 too. So that is why I'm investigating alternatives - just because I'd like some

Re: [PHP] Date handling

2004-11-15 Thread Ryan
Hi Justin, Thanks for your reply. Actually the main issue that I'm running into is that I cannot get Unix timestamps before 1970. I'm running on Red Hat Enterprise Linux (kernel 2.4.21-20.EL). If I run: the script outputs "-1", which then of course translates to 1969-12-31. According to htt

Re: [PHP] Date handling

2004-11-15 Thread Justin French
On 16/11/2004, at 7:05 AM, Ryan wrote: I would like to find out the 'official' way to handle dates in PHP. I am aware of the limits on a Unix timestamp, but I am writing a financial application that needs to deal with dates both before 1970 and after 2038 and of course have run into problems whe

Re: [PHP] Date handling

2004-11-15 Thread Ryan King
On Nov 15, 2004, at 2:05 PM, Ryan wrote: Hello, I would like to find out the 'official' way to handle dates in PHP. There are many paths, choose the one best for you. :-) I am looking at the PEAR Date module and that seems to resolve these issues, but I would like to know if that is the standard/o

[PHP] Date handling

2004-11-15 Thread Ryan
Hello, I would like to find out the 'official' way to handle dates in PHP. I am aware of the limits on a Unix timestamp, but I am writing a financial application that needs to deal with dates both before 1970 and after 2038 and of course have run into problems when trying to format those dates