Subject Re: system date & time into SP
Author Adam
--- In, "Sasa Mihajlovic"
<majstoru@...> wrote:
> Hi,
> I would like to write a Firebird SP that will insert system date and
> time into 2 fields of changed record into some table.
> What is syntax for this SP?

CURRENT_DATE and CURRENT_TIME can be used for this. Any reason to
split this into two fields though?

CAVEAT: Firebird will return for you the local time, not UTC (unless
your server happens to be set to UTC+0). You will need to write your
own (or find a third party) UDF to provide this functionality.