Available inDSQL, PSQL, ESQL


'NOW' is not a variable, but a string literal or datetime mnemonic. It is, however, special in the sense that when you CAST() it to a date/time type, you will get the current date and/or time. Since Firebird 2.0 the precision is 3 decimals, i.e. milliseconds. 'NOW' is case-insensitive, and the engine ignores leading or trailing spaces when casting.



   |select 'Now' from rdb$database
   |-- returns 'Now'
   |select cast('Now' as date) from rdb$database
   |-- returns e.g. 2008-08-13
   |select cast('now' as time) from rdb$database
   |-- returns e.g. 14:20:19.6170
   |select cast('NOW' as timestamp) from rdb$database
   |-- returns e.g. 2008-08-13 14:20:19.6170