Home » SQL & PL/SQL » SQL & PL/SQL » is there a system table that contains SYSDATE column
is there a system table that contains SYSDATE column [message #1126] Wed, 03 April 2002 03:03 Go to next message
Kevin
Messages: 45
Registered: February 2000
Member
Hi all,

I know you can do:

select sysdate
from dummy_table

and you will get the system date but I need to know where i can get the real COLUMN sysdate i.e in which tables.

thanks,

Report message to a moderator

Re: is there a system table that contains SYSDATE column [message #1128 is a reply to message #1126] Wed, 03 April 2002 04:06 Go to previous message
Epe
Messages: 99
Registered: March 2002
Member
Hello,

sysdate is not a column in a table. It's a function...
Maybe there are tables with a column called sysdate, but in that case, it's just the name of a column containing a date (hopefully the date of the system at the moment of record creation).
If you "select sysdate from dual;", you are actually addressing the sysdate function, not a table column...

I hope this will lead to a solution...

Success,

epe

Report message to a moderator

Previous Topic: pro cedure
Next Topic: converting sql query into a procedure
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 17 21:53:04 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.