Current date/time in InterBase (Views: 30)
Problem/Question/Abstract: 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 values(cast('now' as DATE), 'Test') |