Current Date in where clause
Use current_date:

where SALEITEMS.FP_DATE = current_date


This assumes that FP_DATE has the data type DATE . 

If FP_DATE is a timestamp column, then the above will only return rows where the time part of the column is 00:00:00. To ignore the time part you could cast the column to a date value:

where cast(SALEITEMS.FP_DATE as date) = current_date


That however will not make use of an index on the column so it might not be fast enough. In that case the usual approach is to use a range query:

where SALEITEMS.FP_DATE &gt;= current_date
  and SALEITEMS.FP_DATE &lt; current_date + 1


current_date + 1 is "tomorrow" (at midnight)