hours,minutes,seconds not showing in the database

[krizzie khonnie]

Hi,

Can anyone help?

How can I show the the correct format if I used this code [PHP]:B_ros_poe_entr y.last_saved_da te := SYSDATE;[/PHP].

I'm expecting that this should generate MM-DD-YYYY HH:MM:SS but the problem is it's only the MM-DD-YYYY that is only showing on the database. What should I do inorder for the format of the date (MM-DD-YYYY HH:MM:SS ) should appear on the data base or on our table? BTW, the data type used for the column last_saved_date is date.

Please help!!

[r035198x]

How did you know that the time part was not stored? Which query did you run to get both the date and time parts?

What is the output of TO_CHAR(yourCol umnName, 'DD-MON-YYYY HH:MI:SS')?