Home » Developer & Programmer » Forms » $$dbdate$$
$$dbdate$$ [message #402163] Thu, 07 May 2009 23:11 Go to next message
majid tahir
Messages: 39
Registered: July 2007
Location: Pakistan
Member
What is the table for dbdate and in which schema it is located.

[MERGED by LF]

[Updated on: Fri, 08 May 2009 00:34] by Moderator

Report message to a moderator

Re: $$dbdate$$ [message #402164 is a reply to message #402163] Thu, 07 May 2009 23:13 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>What is the table for dbdate and in which schema it is located.
There is no such table as supplied by Oracle.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
$$dbdate$$ [message #402167 is a reply to message #402163] Thu, 07 May 2009 23:25 Go to previous messageGo to next message
majid tahir
Messages: 39
Registered: July 2007
Location: Pakistan
Member
When i change the local system date the dbdate also changes. I want to restrict the dbdate.
Re: $$dbdate$$ [message #402187 is a reply to message #402167] Fri, 08 May 2009 00:37 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Restrict to what?
Re: $$dbdate$$ [message #402188 is a reply to message #402187] Fri, 08 May 2009 00:41 Go to previous messageGo to next message
majid tahir
Messages: 39
Registered: July 2007
Location: Pakistan
Member
when i change the local system date the $$dbdate$$ should not change.
Re: $$dbdate$$ [message #402193 is a reply to message #402188] Fri, 08 May 2009 01:04 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How would you explain usage of the $$dbdate$$? What is it, what does it represent?
Re: $$dbdate$$ [message #402197 is a reply to message #402193] Fri, 08 May 2009 01:12 Go to previous messageGo to next message
majid tahir
Messages: 39
Registered: July 2007
Location: Pakistan
Member
the dbdate is a date from the database. It should not change with sysdate.
Re: $$dbdate$$ [message #402208 is a reply to message #402197] Fri, 08 May 2009 01:40 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What do you call a "sysdate" (in your last message)? In Oracle, SYSDATE is a function that returns the current date and time set for the operating system on which the database resides.

$$dbdate$$ is Forms system variable and it shows current date on the server machine.

$$date$$ is another Forms system variable that shows local system date.

Now: where is your database located? Is it installed on your PC? If so, both $$dbdate$$ and $$date$$ as well as SYSDATE will return the same value.
Re: $$dbdate$$ [message #402220 is a reply to message #402208] Fri, 08 May 2009 02:21 Go to previous message
majid tahir
Messages: 39
Registered: July 2007
Location: Pakistan
Member
yup the database is installed on my local pc. Thank for your response.
Previous Topic: Retrieving image from the database
Next Topic: read forms path in the code from forms environment
Goto Forum:
  


Current Time: Sun Dec 04 02:39:38 CST 2016

Total time taken to generate the page: 0.09484 seconds