Subject Re[2]: [firebird-support] Dynamic SQL Error
Author Pavel Menshchikov
Hello Grant,

GB> Found the problem
GB> When I changed

GB> FTime= 'Now' - (3/1440);

GB> to

GB> FTime= 'Now';
GB> FTime= :FTime - (3/1440);

GB> the error went away.
GB> Seems to me they both equate to the same thing.
GB> Could someone expalin why the error ?
'Now' is just a string, which can be recognized by FB and
auto-converted to a timestamp. I suppose that in your expression FB is
confused. I think the following construction should work fine:

FTime = cast('Now' as TimeStamp) - 3/1440;

Best regards,
Pavel Menshchikov