var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: ORA-00933: SQL command not properly ended
I am trying to set up the query so that it displays all orders from 2012.
I've got this so far:
I think its because of the >=to_date but cannot figure it out.
where *, "DATE_ORDERED" >= to_date ('01/01/2012', 'dd/mm/yyyy')AND order_date <= to_date(''12/12/2012', 'dd/mm/yyyy')
Last edited by MicroB; 03-04-13 at
You have an invalid comma after the first condition in the WHERE clause.
In your second to_date, you have two quotes before the date string and break yourself of the habit of using double quotes around everything. It will come back to haunt you. and the year ends on 12/31/2012, not 12/12/2012.
You do not need a parachute to skydive. You only need a parachute to skydive twice.
This is what your current code look like (you modified the original message after two replies were post, so I have no idea what the original code looked like):
Where did you find such a syntax? What is supposed to mean?
where *, "DATE_ORDERED" >= to_date ('01/01/2012', 'dd/mm/yyyy')
AND order_date <= to_date(''12/12/2012', 'dd/mm/yyyy')
Did you read what you wrote before posting such a mess over here?