OraFAQ Forum: Forms » date type format error.

Home » Developer & Programmer » Forms » date type format error.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

date type format error. [message #208413]

Sun, 10 December 2006 13:08

lunate
Messages: 74
Registered: October 2006
Location: Pakistan

Member

hi all.
i wrote

Quote:

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:

Quote:

03:56 pm.

regards.

Report message to a moderator

Re: date type format error. [message #208420 is a reply to message #208413]

Sun, 10 December 2006 15:30

Littlefoot
Messages: 21818
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.

Report message to a moderator

Previous Topic:	FORMS 6.0i -> Forms 9i
Next Topic:	problem with LOV

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 13:36:06 CDT 2024