Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

TO_DATE(TO_CHAR(sysdate, 'MM/DD/YYYY'), 'MM/DD/YYYY')

427608Nov 14 2005 — edited Nov 15 2005
Hi all,
I am working with a Oracle 9i R2 database

SQL>select TO_CHAR(sysdate, 'MM/DD/YYYY') CHRDATE from dual;

CHRDATE
----------
11/14/2005

SQL>select TO_DATE(TO_CHAR(sysdate, 'MM/DD/YYYY'), 'MM/DD/YYYY') mydate from dual;

MYDATE
---------
14-NOV-05

I want to retain the 4 digit year. Please suggest what I am doing incorrect.

Thanks

Comments

jsmith
Research eventFilters in combination with event.consume():
http://docs.oracle.com/javafx/2.0/api/javafx/scene/Node.html#addEventFilter%28javafx.event.EventType,%20javafx.event.EventHandler%29

Other ways to accomplish this may be via a custom selectionModel:
http://docs.oracle.com/javafx/2.0/api/javafx/scene/control/SelectionModel.html
http://docs.oracle.com/javafx/2.0/api/javafx/scene/control/TreeView.html#setSelectionModel%28javafx.scene.control.MultipleSelectionModel%29

Or by adding a ChangeListener to the selectedItems property of a the default TreeView selectionModel and setting the items to not be selected if it is the at the first "depth".
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 13 2005
Added on Nov 14 2005
#forms, #moved-from-devops
2 comments
419,665 views