Hello Svend,

SMN> I think I remember that I have read somewhere that it is possible to get the
SMN> current time and date in a stored procedure. As far as I remember it should
SMN> be possible with a NOW operator but I can't get it to work. Is it something
SMN> I have dreamt or is there a way? :-)
SMN> I am using FireBird version 1.5.
NOW is not an operator, NOW is just a string. So you should use it in
a way like this:
SomeTimestampVar = 'NOW'; -- note single quotes


HTH
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com