David Smith

David Smith

  • NA
  • 2k
  • 0

Oracle Sql Query by month and year

Mar 12 2014 3:05 AM
I am trying to come up with an oracle sql query to get parts purchase in February 2007. Review InvoiceExample table below.
Table Name: InvoiceExample
 
InvoiceID InvoiceDate PartsPurchase
1 2/4/2007 Bike
2 2/5/2006 Piano
3 2/6/2007 Car
4 2/7/2007 House
 
 
The result is:
 
 
1 2/4/2007 Bike
3 2/6/2007 Car
4 2/7/2007 House

Answers (1)