0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for ebook publishers and readers

with FirstPost as (

    select min(id) as Id
    from Posts

), FirstDay as (

    select Convert(Date, CreationDate) as FirstDate
    from Posts inner join FirstPost on Posts.Id = FirstPost.Id

)
select * from FirstDay

view current version

edited dec 11 14

created jan 17 14 rolfl