Re: date_format

From: Geoff Muldoon (gmuldoon_remove_this_bit__at_scu.edu.au)
Date: 01/27/04 

Date: Wed, 28 Jan 2004 09:18:43 +1100

growler8@hotmail.com says...
> I have some data in an oracle database which has a data type of DATE and the
> dates are stored as 2004-01-20 17:43:49.0
>
> When I get that information via PHP it outputs as 27-JAN-04

Looks like the default Oracle date output format, rather than a PHP
issue.

Use the inbuilt Oracle function, eg.:

select to_char(sysdate, 'YYYY-DD-MM HH24:MI:SS') as "FORMAT_DATE" from
dual;

Relevant Pages