Home » Developer & Programmer » Forms » *** Failor to insert date with time ***
*** Failor to insert date with time *** [message #78029] Fri, 04 January 2002 18:03 Go to next message
Messages: 73
Registered: October 2001
I cannot insert date with time format (saydate,'dd-mm-yy-hh-mi')from form text fiels(date type) to table date field. form field show always 12:00 (when form field's format mask is 'hh:mi') but at that moment sysdate was 11 am, whatever sysdate it is always showing 12:00 in form text field.
I want to inset date with time form form6 of dev2000. Pls help me.


Re: *** Failor to insert date with time *** [message #78031 is a reply to message #78029] Fri, 04 January 2002 18:49 Go to previous message
Messages: 77
Registered: August 2000
Try this:
to_char(sysdate,'dd-mm-yyyy hh24:mi AM')
or this: to_char(sysdate,'dd-Mon-yyyy hh:mi AM')
Now you can change items property like this:
initial value = $$DBDATETIME$$ if you are getting from database or just $$DATETIME$$
and then format mask as: DD-MON-YYYY HH:MI.
Hope this is what you want.

Previous Topic: Web Deployment
Next Topic: set_item_property
Goto Forum:

Current Time: Sun Jun 13 12:13:22 CDT 2021