framework/resources/Functional/int96/q7.sql_drill5495

-- extract month from timestamp
select count(*) from imp_t1 where CAST(EXTRACT(second from CONVERT_FROM(c_timestamp, 'TIMESTAMP_IMPALA')) as INT) = 45;