select '2022-09-15 04:44:05.000'::date as ttd_date

select

datediff(day, current_date, ttd_date) as Days,

datediff(hour, current_date, ttd_date) as hours,

datediff(minute, current_date, ttd_date) as minutes,

datediff(second, current_date, ttd_date) as sex

from tdate