Sql Shorthand For Dates

Posted by vigilant on Stack Overflow See other posts from Stack Overflow or by vigilant
Published on 2009-12-01T21:42:16Z Indexed on 2010/05/03 21:58 UTC
Read the original article Hit count: 393

Filed under:
|
|

Is there a way to write a query equivalent to

select * from log_table where dt >= 'nov-27-2009' and dt < 'nov-28-2009';

but where you could specify only 1 date and say you want the results for that entire day until the next one.

I'm just making this up, but something of the form:

select * from log_table where dt = 'nov-27-2009':+1;

© Stack Overflow or respective owner

Related posts about sql

Related posts about query