OraFAQ Forum: Forms » Datetime Format

Home » Developer & Programmer » Forms » Datetime Format (Oracle8i Form6i)

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

Datetime Format [message #501815]

Thu, 31 March 2011 13:03

mkhalil
Messages: 108
Registered: July 2006
Location: NWFP Peshawar Pakistan

Senior Member

Dear Fellow,

I have written the following assignment statement.

:dshift_hdr.startdate := to_date(sysdate,'DD-MM-RR HH12:MI:SS');

the startdate is a display item. Its data type property has been set to datetime and the formatmask is DD-MM-RRRR HH12:MI:SS but the result of above assignment statement is 31-03-2011 12:00:00 i.e. it does not take the actual current time.

Please help me because i have promised to install the application to the client tommorrow. Thanks in advance.

Muhammad Khalil

Report message to a moderator

Re: Datetime Format [message #501816 is a reply to message #501815]

Thu, 31 March 2011 13:10

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>to_date(sysdate,'DD-MM-RR HH12:MI:SS')
NEVER use TO_DATE on a DATE datatype; like SYSDATE

what datatype is STARTDATE?

Report message to a moderator

Re: Datetime Format [message #501817 is a reply to message #501816]

Thu, 31 March 2011 13:25

Bill B
Messages: 1971
Registered: December 2004

Senior Member

You have to use datetime in forms, not date

Report message to a moderator

Re: Datetime Format [message #501834 is a reply to message #501817]

Thu, 31 March 2011 21:54

mkhalil
Messages: 108
Registered: July 2006
Location: NWFP Peshawar Pakistan

Senior Member

Thanks BlackSwan and Bill B for such a stong advice. My problem has solved now.

Report message to a moderator

Previous Topic:	hide menu bar and tool bar of the browser at form run time
Next Topic:	image / BLOB_TABLE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 17 05:04:56 CDT 2024