OraFAQ Forum: Forms » use of $$DBDATETIME$$ at other than initial value

Home » Developer & Programmer » Forms » use of $$DBDATETIME$$ at other than initial value (Forms 6.0.8)

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

use of $$DBDATETIME$$ at other than initial value [message #606432]

Thu, 23 January 2014 17:48

bluetooth420
Messages: 146
Registered: November 2011

Senior Member

Hi

The help says that $$DBDATETIME$$ can be used in initial value or lower/higher value property.

Is there anyway to read the Database date and time and assign it to database field on forms (as initialization date+time and saving date+time is different, sometimes, in my application, hence creating problems)?

I have received error in the following code

:inv0s.mydate := :system.$$DBDATETIME$$;

Any idea ???

Thanks

-BT

Report message to a moderator

Re: use of $$DBDATETIME$$ at other than initial value [message #606433 is a reply to message #606432]

Thu, 23 January 2014 18:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://docs.oracle.com/cd/E11882_01/server.112/e41084/functions191.htm#SQLRF06124

Report message to a moderator

Re: use of $$DBDATETIME$$ at other than initial value [message #606440 is a reply to message #606433]

Thu, 23 January 2014 23:56

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Would

:inv0s.mydate := sysdate;

be good enough for you?

Report message to a moderator

Re: use of $$DBDATETIME$$ at other than initial value [message #606482 is a reply to message #606433]

Fri, 24 January 2014 09:44

bluetooth420
Messages: 146
Registered: November 2011

Senior Member

Thanks BlackSwan.
I thought that sysdate will show local client date and time.

Thanks for your guidance.

Report message to a moderator

Re: use of $$DBDATETIME$$ at other than initial value [message #606491 is a reply to message #606482]

Fri, 24 January 2014 12:36

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

SYSDATE is the database server time.

Report message to a moderator

Previous Topic:	update records- trigger
Next Topic:	Delete Multiple Records

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 11:30:12 CDT 2024