php: date conversion to dd-mm-YYYY format

I'开发者_JAVA技巧m trying to convert this timestamp format which I got from an Oracle sql query:

19-SEP-11 02.34.51.558459 PM

I need to convert it to this format: dd-mm-YYYY.

$install_date=strtotime($install_date);
$install_date=date("d/m/Y",strtotime($install_date));

but I'm getting weird results...

Any ideas?

*** forgot to mention, the field type is TIMESTAMP and not DATETIME

---

When dealing with formats that strtotime() cannot handle (see supported date and time formats), or even if you are, then you can create a DateTime object from any format using DateTime::createFromFormat() (or it's procedural twin, date_create_from_format()) (docs).

$install_date = '19-SEP-11 02.34.51.558459 PM';
$datetime     = DateTime::createFromFormat('j-M-y h.i.s.u A', $install_date);
$datetime_dmy = $datetime->format('d/m/Y');

---

If it is a datetime field in Oracle, you could use

TO_CHAR(fieldName, 'DD-MM-YYY')

In your select, then it would be formatted as it comes out of the database.

---

Do this instead:

$install_date=strtotime($install_date);
$install_date=date("d/m/Y",$install_date);

You had already converted $install_date to internal time, then you were doing it again in the second line.

Of course, you can cut it all down to one line if you like:

$install_date=date("d/m/Y",strtotime($install_date));