Stack Exchange
log in help

select * from postswithdeleted where cast(deletiondate as...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Writing

Q&A for the craft of professional writing, including fiction, non-fiction, technical, scholarly, and commercial writing

select *
   from postswithdeleted
   where cast(deletiondate as date) = '2023-11-30'
    and posttypeid = '2'
    and parentid is not null
  ;
fork query

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results