Sql Shorthand For Dates -

Choose what type of query

  choose from log_table where 'dt & gt; = 'Nov-27-2009' and DT & lt; 'Nov-28-2009';  

But you can only specify on 1 date and say that the next day the result should be for the entire day.

I'm just making it up, but something like this:

  select from log_table * where dt = 'neo-27-2009': + 1;  
 
 I do not think there is a method which is portable for all RDBMSes 
 
 In one of my references, the investigation () shows that no RDBMS solves the problem in the same way, I recommend to check Chapter 8 of that book, which includes DB2, Oracle, All different methods have been included for postgresql, mysql. 
 
 I do not address   with this problem, however, and SQL cookbook RDBMS, so I will mention something about it here.   does not have date / time data type in SQLite  ; You must create all your date / time data by storing it as  TEXT  and make sure that your application implements its formatting, which is a set of SQLite data, Allows you to add a nominal date / time while retaining in case you want to add two periods of each time (hh: mm: ss), however, depending on the data that you have typed T column, which you are treating as a date / time data, you need to call (search "definition of SQLite user work") and call  sqlite3_create_function ()  Attach them to the database at runtime. If you want an example of some user functions that add time values, let me know.