I have a MODIFY_DATE timestamp column with values like this
I am trying to get the Distinct Date from the column, my resultset should look like this
what i have is
select distinct cast(MODIFY_DATE AS Date) as Date from CUSTOMER_TABLE
where cast(MODIFY_DATE AS Date) = DATEADD(day, 0, convert(date, GETDATE()))
but this will get only todays date.
Any idea how i can acchieve this?