kuhajeyan kuhajeyan - 5 months ago 22
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

I think you can do:

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