Subject Re: [firebird-support] Stored Procedure - now ?
Author Martijn Tonies
> 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 ?


as in:

select current_timestamp from rdb$database


insert into .. values (current_timestamp)

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Upscene Productions
Database development questions? Check the forum!