Script executing sql query

Shell Programming and Scripting
1

Hello,

I have a sh script excuting a sql query through sqlplus. I am having trouble making my date equal to the date of the server time in the sql script. How can i call the server date from my query?

Thanks

2

I'm not understanding the problem. You want to get the time/date on the server then use it in your query? Just use the variable "SYSDATE" in your query, it is the current time on the server. example:

SELECT STUFF FROM MYTABLE WHERE TABLE_DATE > SYSDATE -1;

-- finds all of the rows in mytable where the table_date field has a value that is less than one day.

3

Thanks for your help! It works!! :smiley: