Need to save dates in Oracle Forms 10g without modifying data values

15 pts.
Tags:
Database management
Oracle 10g Database
Oracle 11g Database
Oracle Forms 10g
I am trying to save date and time as entered by the users example: In the insert and update triggers of my block my statement is: :MAIN_BLOCK.USER_DATE := TO_DATE(TO_CHAR(:MAIN_BLOCK.USER_DATE,'DD-MON-YYYY')||' '||:MAIN_BLOCK.HOUR||':'||:MAIN_BLOCK.MIN||':00 '||:MAIN_BLOCK.MERIDIAN,'DD-MON-YYYY HH:MI:SS AM').  I am trying to save :MAIN_BLOCK.USER_DATE as "25-MAY-2010 11:00:00 AM" as the user entered in the form textboxes and is saving "25-MAY-2010 12:00:00 AM". Why do it changes the time value? Thanks!



Software/Hardware used:
ORACLE 10G FORMS AND ORACLE 11G DATABASE

Answer Wiki

Thanks. We'll let you know when a new response is added.

Make sure your :MAIN_BLOCK.USER_DATE item’s data type is DATETIME and not DATE.

DATE items don’t store a time component.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Starletmyra
    Yes, I realized it and changed the Date data type to Datetime! Thanks a lot for your time and answer! Blessings!
    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following