Barry 'Date() - 14' isn't constant - the Date() function is designed specifically to be evaluated each time. '@DATE - 14', on the other hand, should be constant.
You should see a difference between the two if you run a query across midnight... Same with TIME() and @TIME: try both on a long LIST or SORT and you'll see what I mean :) Brian > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen > Sent: 16 July 2009 16:39 > To: U2 Users List > Subject: [U2] Universe Retrieve > > > Question: If you are doing a select statement and within > the statement you have a eval phrase and this eval phrase > contains all constants (ie, DATE() - 14), does Universe > recalculate that constant value with each record iteration or > is it smart enough to know that this is a constant value and > therefore only calculates it once ? > > Barry Rogen > PNY Technologies, Inc. > Senior Programmer/Analyst > (973) 515 - 9700 ext 5327 > bro...@pny.com > > ----------------------------------------------------- > We are continually faced with great opportunities > brilliantly disguised as insoluble problems. > > John W Gardner > ---------------------------------------------------------------- > P Before printing please think about your environmental responsibility > > > > 16/7/2009NOT INTENDED AS A SUBSTITUTE FOR A WRITING > > NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY > BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A > BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR > ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, > NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC > TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE > OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL > MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO > REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A > CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF > WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL > ALTER THIS DISCLAIMER. > > This e-mail message from PNY Technologies, Inc. is for the > sole use of the intended recipient(s) and may contain > confidential and privileged information. Any unauthorized > review, use, disclosure or distribution is prohibited. If you > are not the intended recipient, please contact the sender by > reply e-mail and destroy all copies of the original message. > > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
