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
Messages: 1
Registered: March 2010
Junior Member

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
Messages: 12793
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: 65085
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I confirm that SYSDATE is calculated once for the whole query.

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: Sun Jul 23 16:00:29 CDT 2017

Total time taken to generate the page: 0.12533 seconds