how to convert date and time?

Hi guys.. can any body teach me how to convert date and time formats?

example if the format of date in the database is 2010-02-12 and i want to convert it to Febuary 12, 2010 to be shown to the users.. and in time, if the format is in 24hrs and i want to change it to 12hrs format..

Use strtotime()

strtotime() will just give you the unix timestamp for the date. You have to use date() to convert the timestamp intot the format you want. So for what you want:

PHP Code:

date("F j, Y",strtotime("2010-03-00")); 


A standard DateTime format string consists of a single standard DateTime format specifier character that represents a custom DateTime format stringCustom DateTime Format Strings. The format string ultimately defines the text representation of a DateTime object that is produced by a formatting operation. Note that any DateTime format string that contains more than one alphabetic character, including white space, is interpreted as a custom DateTime format string...

The code is works perfectly for me.

string date ( string $format [, int $timestamp ] )

Returns a string formatted according to the given format string using the given integer timestamp or the current time if no timestamp is given. In other words, timestamp is optional and defaults to the value of time().

Here is all you need:
strtotime() - Parse about any English textual datetime description into a Unix timestamp

date() - Format a local time/date from a Unix timestamp

Examples:
24 Hour to 12 Hour conversion

echo date("g:i a", strtotime("13:30:30"));

12 Hour to 24 Hour conversion

echo date("H:i:s", strtotime("1:30 pm"));

Easy as that!

it works for me too. were u able to get it

Another way (but lengthy) could be that you create a hash with the months and days and then show them in whatever way you feel like using sprintf()

Thanks bodyboard for sharing this code, it's working.

That's useful and interesting.