Question:
How can I determine the current date / time in InterBase? (Version 5.0)
Answer:
InterBase supports four DATE literals. They are: 'today', 'yesterday', 'tomorrow' and 'now'
Use it with a cast as shown in the example below.
insert into mytable
(TIME_FIELD, MESSAGE_FIELD)
values(cast('now' as DATE), 'Test')