kuhajeyan kuhajeyan - 1 year ago 85
SQL Question

how to get today date in YYYYMMDD in firebird

how to get today date in YYYYMMDD in firebird, I had a look on following but could not figured how to write this.

Answer Source

I think you can do:

select replace(cast(cast('Now' as date) as varchar(10)), '-', '')
from rdb$database