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: 21127
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: Sat Jul 22 08:18:50 CDT 2017

Total time taken to generate the page: 0.16259 seconds