In article <[EMAIL PROTECTED]
maeci.gc.ca>, [EMAIL PROTECTED] says...
> Having a little trouble with converting dates.
>
> I have, in my database, a bunch of dates stored like this: YYYY-M. Month is
> obviously the number of the month (5), not the name (May).
>
> I want to convert the format to MMM, YYYY (ex: May, 2002), so I used the
> mktime function. Basically I extract the date with a regular MySQL query,
> then explode the date, and my components look great. However, when I put the
> components into my mktime function, sometimes it'll work and sometimes it
> won't. It won't work if the date is too far off in the future (2085, etc.),
> but I'm not exactly sure what the cutoff is. If it's recent, say 2005, it
> works fine.
>
> My code is this (after grabbing the query results):
> $enddate = explode("-", $datereuslt[0]);
> $fullenddate = mktime(0, 0, 0, $enddate[1], 0, $enddate[0]);
> $finaldate = date("M, Y", $fullenddate);
>
> Any ideas? Alternatively, if anyone has an easier way of doing this, I'm all
> ears.
>
Hmm, as mktime returns a unix timestamp it'll be constrained by that;
currently the unix timestamp covers a range from 1 Jan 1970 to (mumble)
January 2038.
However, if your date is stored using one of the mysql date or time
formats, why not try using mysql's DATE_FORMAT to pretty it up as you
select from the db? IIRC some of the date column types have a range of
around 10,000 years, which should meet your needs.
--
David Robley
Temporary Kiwi!
Quod subigo farinam
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
