SQL & PL/SQL

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!

date format and strange 00:00:00.0

531367Sep 13 2006 — edited Sep 14 2006

I am using jdbc to read data in oracle.
When I read date column type, it always has format like:
2005-01-01 00:00:00.0

I am supprised because when I read (also via jdbc)
SYS.NLS_SESSION_PARAMETERS table, I found there
NLS_DATE_FORMAT RR/MM/DD

Do you known why during selects I do not see such format?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 12 2006

Added on Sep 13 2006

2 comments

1,124 views