Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Selecting results for month to date

Selecting results for month to date

From: VB <vodkablokey_at_gmail.com>
Date: 6 Oct 2006 05:48:45 -0700
Message-ID: <1160138925.586275.272080@h48g2000cwc.googlegroups.com> 





I have been asked to modify an existing report for deliveries in the
last 24 hours to be deliveries for the month to date.



At the moment the where statement includes sysdate -1



Is there a more elegant way to select all diliveries after midnight on
the first day of the month?



Sorry to be an ignorant questioner, but our SQL person has left the
company so all help is greatly appreciated.
Received on Fri Oct 06 2006 - 07:48:45 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US