By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,903 Members | 1,977 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,903 IT Pros & Developers. It's quick & easy.

hours,minutes,seconds not showing in the database

P: 11

Can anyone help?

How can I show the the correct format if I used this code [PHP]:B_ros_poe_entry.last_saved_date := 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!!
Oct 23 '08 #1
Share this Question
Share on Google+
1 Reply

P: 13,264
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(yourColumnName, 'DD-MON-YYYY HH:MI:SS')?
Oct 23 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.