Home » SQL & PL/SQL » SQL & PL/SQL » sysdate performance (Oracle 10g)
sysdate performance [message #448506] Tue, 23 March 2010 17:20 Go to next message
sandeeprh
Messages: 1
Registered: March 2010
Junior Member
Hello,

In a query that returns over 10000 records, can we have the sysdate to be calculated only once?


I need to compare some date column with today's date ( I dont care about the minutes and seconds).

I cannot use variables outside the query.


Thanks in Advance,
Re: sysdate performance [message #448508 is a reply to message #448506] Tue, 23 March 2010 18:04 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
I'm pretty sure sysdate will only be calculated once. Why do you think it's a problem?
Re: sysdate performance [message #448535 is a reply to message #448506] Wed, 24 March 2010 00:41 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I confirm that SYSDATE is calculated once for the whole query.


Regards
Michel
Tell me and I'll forget; show me and I may remember; involve me and I'll understand

[Updated on: Wed, 24 March 2010 00:41]

Report message to a moderator

Previous Topic: Can a nested select be passed as a parameter?
Next Topic: using clob instead of varchar2
Goto Forum:
  


Current Time: Fri Dec 09 03:34:13 CST 2016

Total time taken to generate the page: 0.15390 seconds