Home » Developer & Programmer » Forms » date field with time (Oracle Forms, 10.1.2.3, Linux)
date field with time [message #443639] Tue, 16 February 2010 12:10 Go to next message
dlwixon
Messages: 92
Registered: September 2008
Member
I have a display item form field. The field's data type is date. It is also a database field that corresponds to a date field in the table.

I have set the format mask on the form field to
MM/DD/YYYY HH24:MI:SS

I can populate that field with sysdate in when-new-form-instance.

However, if I try to get the date and the time in the field, it just populates the date with the time of 00:00:00.
(02/16/2010 00:00:00 for example).

I have tried several to_char and to_date variations but can't seem to get the current time into that field.

Any suggestions?

Re: date field with time [message #443649 is a reply to message #443639] Tue, 16 February 2010 12:59 Go to previous messageGo to next message
joy_division
Messages: 4643
Registered: February 2005
Location: East Coast USA
Senior Member
Try $$DATETIME$$ in the Initial Value, although I am not quite sure I understand what you are having a problem with.
Re: date field with time [message #443651 is a reply to message #443649] Tue, 16 February 2010 13:39 Go to previous messageGo to next message
dlwixon
Messages: 92
Registered: September 2008
Member
You may not have understood my problem but you gave me the solution. Thanks!
Re: date field with time [message #443652 is a reply to message #443639] Tue, 16 February 2010 13:49 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
dlwixon wrote on Tue, 16 February 2010 19:10
I have a display item form field. The field's data type is date.

Should be DATETIME, I presume.
Re: date field with time [message #444206 is a reply to message #443639] Fri, 19 February 2010 06:00 Go to previous messageGo to next message
chessmaster.grandmaster
Messages: 3
Registered: February 2010
Location: Faisalabad
Junior Member

i want to take the input of date as

160210
This save in the system as

16-Feb-2010

How that is Possible .

I want to save the Key stoke of end user

Re: date field with time [message #444210 is a reply to message #443639] Fri, 19 February 2010 06:12 Go to previous message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
Use the format mask DDMMRR
Previous Topic: FRM-21011: PL/SQL unhandled exception ORA-306500
Next Topic: java.lang.classNotFoundException: oracle.forms.engine.Main
Goto Forum:
  


Current Time: Thu Dec 08 22:11:10 CST 2016

Total time taken to generate the page: 0.07447 seconds