I'm trying to do a query on only questions that are not closed, and the ClosedDate query returns a DateTime object. I was wondering what the default value of DateTime was, as I can select only those with a DateTime of that. I looked on the documentation of T-SQL, and found it was 1900-01-01 00:00:00, but it only accepts the 1900-01-01 part in Data Explorer.

1 Answer 1


The ClosedDate column is nullable, so questions which are not closed are simply posts meeting the criteria

WHERE PostTypeId = 1 AND ClosedDate IS NULL

…which I assume is what you were after.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .