RE: [PHP] Date conversion problems

2002-08-27 Thread Liam . Gibbs
> mktime generally only works thru 2037. Why not create an array of the > months, and index in: > $months = array('Jan','Feb',); > $enddate = explode("-", $datereuslt[0]); > $finaldate = $months[$enddate-1] . "-$enddate[1]"; That's what I thought I might have to do. It's an alternative, but

RE: [PHP] Date conversion problems

2002-08-26 Thread David Freeman
> I have, in my database, a bunch of dates stored like this: > -M. Month is obviously the number of the month (5), not > the name (May). > > I want to convert the format to MMM, (ex: May, 2002), Do the conversion in MySQL - it'll save you grief in the long run... SELECT DATE_F

Re: [PHP] Date conversion problems

2002-08-26 Thread Matt
>From: "Matt" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> >Sent: Monday, August 26, 2002 5:42 PM >Subject: Re: [PHP] Date conversion problems > > From: <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]>

Re: [PHP] Date conversion problems

2002-08-26 Thread Matt
> From: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> >Sent: Monday, August 26, 2002 3:58 PM >Subject: [PHP] Date conversion problems > Having a little trouble with converting dates. > > I have, in my database, a bunch of dates stored like this: -M. Month is > obviously the number of the mon