Heres a copy of the column in question.
AUDITTIMESTAMP
1087846893579
1087924923734
1104764681188
1104732392516
1087846893610
1104741005453
1087846893657
1104693744344
1104741246891
1087846893735
I'm using this statement to see the dates, but I can't get it to work with deleting any records over 30 days old.
SELECT DATEADD(hh, - 05, DATEADD(ss, AUDITTIMESTAMP / 1000, '01/01/1970')) AS ts, *
Thanks