Select entrys within current month

[backtobasics]

I wish to select rows from a table which is within the current month. It is to show 'current months transactions', i.e. give a gross value of the transactions.

What is the best solution for doing this? Using SQL of course.

Thanks

[r937]

Originally Posted by backtobasics

Using SQL of course.

of course

but which database? oracle? db2? sybase? firebird? postgresql? access?

[backtobasics]

MySQL

[r937]

 where datecol 
         >= date_sub(current_date
             , interval dayofmonth(current_date)-1 day)
   and datecol 
          < date_add(
            date_sub(current_date
             , interval dayofmonth(current_date)-1 day)
             , interval 1 month)

note: thread moved to mysql forum

[backtobasics]

Worked perfectly, cheers much!

Merry non-denominational winter break!