Re: [Firebird-docs] TODAY and shorthand casts

2011-10-06 Thread Paul Vinkenoog
Hi Lester, > http://fbwiki.lsces.co.uk/wiki/index.php?page=NOW > Hopefully this is the correct information ... Correct but not entirely complete, with what we now know. You may want to add a warning that when shorthand casts are used (or whatever you want to call them), 'NOW' and friends are ev

Re: [Firebird-docs] TODAY and shorthand casts

2011-10-06 Thread Paul Vinkenoog
Hi all, > Yes, we'll have to document this clearly: > > - When used with CAST() they are evaluated each time the code is executed and > return the current date (or, in the case of 'now', timestamp). In this case, > they are more up-to-date than the CURRENT_ variables, which are > evaluated once