Home » Developer & Programmer » Forms » date type format error.
date type format error. [message #208413] Sun, 10 December 2006 13:08 Go to next message
Messages: 74
Registered: October 2006
Location: Pakistan

hi all.
i wrote
hh:mi am
for 12 hour format in format mask property of my form's field.
it is working well but at back end(oracle 9i database)i got time value for each entry as' 01-dec-2006' .
how can i put the tiem into the table(back-end)using form(front-end)in same format example:
03:56 pm.
Re: date type format error. [message #208420 is a reply to message #208413] Sun, 10 December 2006 15:30 Go to previous message
Messages: 20847
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You can not. DATE datatype contains both DATE and TIME component. If you omit date part of it, it is set to the 1st of current month.

In my opinion, you shouldn't worry about it; though, perhaps it would be better to store the whole data - date + time (instead of 1st of month + time). If business rule says that date is not important, but only time, then OK - for reporting purposes select only time and format it using the TO_CHAR function.
Previous Topic: FORMS 6.0i -> Forms 9i
Next Topic: problem with LOV
Goto Forum:

Current Time: Fri Oct 28 13:41:26 CDT 2016

Total time taken to generate the page: 0.07629 seconds