Script executing sql query

kingluke · #1 (**permalink**) 01-22-2008

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

jim mcnamara · #2 (**permalink**) 01-22-2008

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:

Code:

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.

kingluke · #3 (**permalink**) 01-23-2008

Thanks for your help! It works!!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Need Unix script for executing oracle query	ravi gongati	Shell Programming and Scripting	14	03-24-2008 05:53 AM
Print out loop index on the console after executing each sybase DB query	Alaeddin	Shell Programming and Scripting	2	12-16-2007 04:30 AM
executing a SQL query in shell script	lijju.mathew	Shell Programming and Scripting	1	05-17-2007 11:29 AM
Executing Sql Query Using Shell Script	ragha81	Shell Programming and Scripting	14	07-31-2006 02:15 PM
Executing a SQL query from a shell script	98_1LE	UNIX for Dummies Questions & Answers	3	03-23-2002 03:29 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by