> I have to make a stored procedure now.
> In this procedure I insert some records into a table.
> One of the fields contains a date, which should be set to NOW.
>
> In delphi there is a function called NOW that returns the actual date
> and time.
>
> Does this exists in firebird ?

CURRENT_TIMESTAMP

as in:

select current_timestamp from rdb$database

or

insert into .. values (current_timestamp)



With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com