Skip to Main Content

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!

How to store only time in a date field value?

user10569054Nov 1 2010 — edited Nov 1 2010
Hi,
I've a problem storing only time in date field value by oracle forms.
Actually i'm just updating time in a date field by oracle forms. but it is giving an error "not a valid month"
table column datatype is date.

my DB parameter are
SQL> SELECT * from NLS_INSTANCE_PARAMETERS;

PARAMETER                      VALUE
------------------------------ ----------------------
NLS_LANGUAGE                   american
NLS_TERRITORY                  america
NLS_SORT                       binary
NLS_DATE_LANGUAGE
NLS_DATE_FORMAT                DD-MON-RR
NLS_CURRENCY
NLS_NUMERIC_CHARACTERS         .,
NLS_ISO_CURRENCY
NLS_CALENDAR
NLS_TIME_FORMAT
NLS_TIMESTAMP_FORMAT

PARAMETER                      VALUE
------------------------------ ----------------------
NLS_TIME_TZ_FORMAT
NLS_TIMESTAMP_TZ_FORMAT
NLS_DUAL_CURRENCY
NLS_COMP                       binary
NLS_LENGTH_SEMANTICS           BYTE
NLS_NCHAR_CONV_EXCP            FALSE
Regards!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 29 2010
Added on Nov 1 2010
12 comments
15,279 views