OraFAQ Forum: Forms » date field with time

Home » Developer & Programmer » Forms » date field with time (Oracle Forms, 10.1.2.3, Linux)

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

date field with time [message #443639]

Tue, 16 February 2010 12:10

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?

Report message to a moderator

Re: date field with time [message #443649 is a reply to message #443639]

Tue, 16 February 2010 12:59

joy_division
Messages: 4963
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.

Report message to a moderator

Re: date field with time [message #443651 is a reply to message #443649]

Tue, 16 February 2010 13:39

dlwixon
Messages: 92
Registered: September 2008

Member

You may not have understood my problem but you gave me the solution. Thanks!

Report message to a moderator

Re: date field with time [message #443652 is a reply to message #443639]

Tue, 16 February 2010 13:49

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

Report message to a moderator

Re: date field with time [message #444206 is a reply to message #443639]

Fri, 19 February 2010 06:00

chessmaster.grandmaster
Messages: 3
Registered: February 2010
Location: Faisalabad

Junior Member

mbit.dbms@gmail.com

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

Report message to a moderator

Re: date field with time [message #444210 is a reply to message #443639]

Fri, 19 February 2010 06:12

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Use the format mask DDMMRR

Report message to a moderator

Previous Topic:	FRM-21011: PL/SQL unhandled exception ORA-306500
Next Topic:	java.lang.classNotFoundException: oracle.forms.engine.Main

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 11:29:09 CDT 2024