| Subject | RE: [firebird-support] Current time and date |
|---|---|
| Author | Svend Meyland Nicolaisen |
| Post date | 2005-05-17T20:57:31Z |
> -----Original Message-----Ahh, that is exactly what I was missing. Thank you for your help.
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Pavel
> Menshchikov
> Sent: 17. maj 2005 22:01
> To: Svend Meyland Nicolaisen
> Subject: Re: [firebird-support] Current time and date
>
> Hello Svend,
>
> SMN> I think I remember that I have read somewhere that it is
> possible
> SMN> to get the current time and date in a stored procedure.
> As far as I
> SMN> remember it should be possible with a NOW operator but I
> can't get
> SMN> it to work. Is it something I have dreamt or is there a
> way? :-) I
> SMN> 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
/Svend