Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

question about saving a date/time field to the database

329650Jun 19 2009 — edited Jun 19 2009

Folks,

I'm not a developer, I'm a DBA so I apologize if this is a simple question.
I have a Forms developer who says that I need to change the default SYSDATE on our App Server where Forms is running because when he saves a date/time field in the database from an Oracle Form running on the App Server, it only saves the date portion but the time portion is all 0's.

I know that the default for my database is to store the whole date and time portion.

Is there a setting in Oracle forms that allows the time portion to be saved in the database along with the date when inserting or updating a row with a DATE datatype?

Thanks in advance.

John

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 17 2009

Added on Jun 19 2009

#forms, #moved-from-devops

6 comments

2,869 views