HELP !! How to get full date from Oracle DB

[Mr_Putin]

I inserted record into Orace database Date field.
It was inserted in format to_date(date, 'YYYY.MM.DDHH24:MI')
When I look directly in Oracle , I see "2003.06.15 13:20:00"
But when I select this record with php like this:

$apsk_prietaisai_query = "select * from automat.apsk_prietaisai
where akto_nr= '$akto_nr'";
$apsk_prietaisai_row=array();
ora_parse($curs,$apsk_prietaisai_query );
ora_exec($curs);
while(ora_fetch_into($curs,$apsk_prietaisai_row))
{
......
}
I get $apsk_prietaisai_row[2] = "2003.06.15"
How to get all date and time ??????????????????????????

BTW strlen($apsk_prietaisai_row[2] ) =10

Mayby I have to use some format for output ???

[bastien]

yeah, you need to format the date or you get the default dd-mon-yy

so

select to_char(thedate, 'YYYY.MM.DDHH24:MI') from mytable

[Mr_Putin]

Thanx Bastien
It realy helped ..
You saved my ass 🙂) 😃