--- In firebird-support@yahoogroups.com, "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.

Adam