Interesting use of split().. don't think I've ever used that function but looks
like it'll do just as well and also allow multiple dividers. Thanks for
pointing that out.
As for this:
$mysqldate = $y.'-'.$m.'-'.$d;
The only problem I foresee is what happens when you have single digit days and
months?
2004-9-8
What does MySQL do with this?
What happens if you want the date in another format? It'll take another minute
or two (and leave more potential for typing errors I think) if you did your
date format like this rather than using date() + mktime(). I think
date/mktime gives you more reliability and more flexibility. Just something
to think about. When it comes down to it, whatever works for you, right? :)
-TG
= = = Original message = = =
Thank you for all your help.
Among all the variations I found this to be the clearest:
list($d,$m,$y) = explode("/",$testdate);
$mysqldate = date("Y-m-d", mktime(0,0,0,$m,$d,$y));
But I also thought the use of split instead of explode so you could nominate
multiple delimiters was good.
eg.
list($d,$m,$y) = split('[/.-]', $testdate);
Another variation was to hardcode the date results instead of using the date
function which is very simple:
eg.
$mysqldate = $y.'-'.$m.'-'.$d;
Sorry for asking a question that is obviously asked often.
Interesting comment on 'normal'. I suspect that numerically more of the
world uses dmy than mdy. There is a lot more of the world outside the US
than in it.
Thanks again for all your help.
Neil
___________________________________________________________
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
