PHP formatting date, without using date functions

I am getting date in following format, which is a string:

31_Dec_2010

Now, I need to convert it to following 2 format

2010-12-31 //(for use in mysql query)

and

31 Dec, 2010 //(for displaying purpose)

I cannot use Date-Time Functions because I am running code on PHP 4.8

Please suggest me开发者_如何学编程 some way, other then "explode" function

You can do like this:

echo date('Y-m-d', strtotime(str_replace('_', '-', '31_Dec_2010')));

Output:

2010-12-31

I cannot use Date-Time Functions because I am running code on PHP 4.8

These functions are available in the version of PHP you are using :)

According to the manual PHP's date functions have been available since version 4. Assuming you cant update (for whatever reason), you still should be able to use them.

You should reconsider using explode/split, you can safely split on _ to get each part of the date. The only tedious part of that is to convert the month to the numeric value, MySQL might have some handy syntax for that too.