how-to compare dates in nzsql

-- how-to compare dates with different formats

-- how-to convert timestamp and date to bigint

-- how-to use if else struct

SELECT CASE 

   when 

      cast (to_char( (current_timestamp + interval '0 days' ) , 'yyyymmddHHMMSS') as bigint)=

      cast (to_char(NOW() , 'yyyymmddHHMMSS') as bigint)

   then 

         'are equal'

   else 

          'are NOT equal'

END

;