DelphiFAQ Home Search:
General :: Databases :: InterBase
Help with InterBase, Borland's open source database.


This list is sorted by recent document popularity (not total page views).
New documents will first appear at the bottom.

Featured Article

Current date / time in InterBase


How can I determine the current date / time in InterBase? (Version 5.0)


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 
 values(cast('now' as DATE), 'Test')

Generated 16:00:23 on Feb 26, 2020