| *** Failor to insert date with time *** [message #78029] |
Fri, 04 January 2002 18:03  |
Robin
Messages: 73
Registered: October 2001
|
Member |
|
|
Experts,
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.
Thanks
Robin
----------------------------------------------------------------------
|
|
|
|
| Re: *** Failor to insert date with time *** [message #78031 is a reply to message #78029] |
Fri, 04 January 2002 18:49  |
sokeh
Messages: 77
Registered: August 2000
|
Member |
|
|
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.
sam
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
