How can I get reports for last 24h in SQL?

Posted by newbie on Stack Overflow See other posts from Stack Overflow or by newbie
Published on 2010-05-31T07:27:07Z Indexed on 2010/05/31 7:32 UTC
Read the original article Hit count: 121

Filed under:
|

I need to get all reports made in last 24h, table has CreatedDate column, so I need to check in database that report was created in last 24h. I know I can use getdate() to get current date, but how can I minus 24h from that attrbiute and then compare that date with CretedDate?

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server