Mark Rotteveel wrote:
>> - When used as shorthand casts / datetime literals they are evaluated only
>> once: at parse/prepare time. In this case, they are often*less* up-to-date
>> than the CURRENT_ variables, because the latter are refreshed
>> every time a prepared query is executed again.
On 4-10-2011 17:27, Paul Vinkenoog wrote:
> Dmitry wrote:
>
>>> 'YESTERDAY', 'TODAY' and 'TOMORROW'
>>> These are not context variables, but serve the same purpose. See 'NOW',
>>> which is also documented under Context variables (quotes and all).
>>
>> They can behave as either literals substitute
Dmitry wrote:
> > 'YESTERDAY', 'TODAY' and 'TOMORROW'
> > These are not context variables, but serve the same purpose. See 'NOW',
> > which is also documented under Context variables (quotes and all).
>
> They can behave as either literals substituted immediately (timestamp
> 'today') or as conte
Paul Vinkenoog wrote:
> Will do some more testing tomorrow afternoon. Whatever the outcome, we'll
> have to adapt the documentation at this point.
http://fbwiki.lsces.co.uk/wiki/index.php?page=NOW
Hopefully this is the correct information ...
(Timestamps on files are new as I had to strip some ha