|
|
Re: is there a system table that contains SYSDATE column [message #19722 is a reply to message #19665] |
Thu, 04 April 2002 14:21 |
Su
Messages: 154 Registered: April 2002
|
Senior Member |
|
|
Hi Kevin,
There is no physical column defined for SYSDATE (as per my knowledge) as it is a predefined ORACLE identifier. As you know the SQL is an interactive language, you have to use an SQL statement like SELECT to retrieve the value of SYSDATE. You can use the SYSDATE not only in SELECT, can use also in UPDATE, INSERT, etc SQL statements. It is predefined ORACLE identified/variable which always changes with current date and time. It is not a column of any table. If it is, how can you use it in INSERT, UPDATE, etc statements without a table specification?
The problem is some thing else. Anyway what ORACLE are you using? I mean version.
OK, before you determine something, you first try the simple
SELECT SYSDATE FROM DUAL;
at SQL prompt. It is a basic SQL statement and should return with no error. If it is good, then the culprit is in your query/report. Check it out.
Good luck :)
|
|
|