Date query 1

[mcowen]

Hi all,
I am looking to do a query that retrieves the dates in a table that are todays date.

I tried this

select date_time, refnum from inventory where date_time > to_date('17-FEB-02, 12:00:00')
*
ERROR at line 1:
ORA-01830: date format picture ends before converting entire input string

I dont think I am handling the date input correctly. Any idea how to do the comparison please?

Rgds
Matt

 

[sfvb]

select date_time, refnum
from inventory
where date_time > to_date('17-FEB-2002', 'DD-MON-YYYY')

also:

select date_time, refnum
from inventory
where date_time >= trunc(sysdate)

 

[sfvb]

I made an error in the first statement, you'd need to change the ">" to ">=".

 

[karluk]

Your specific problem is that Oracle is using the default date format in the to_date function and this default is not compatible with the date string you are trying to convert. To correct this you need to supply an explicit date format, as sfvb suggests. Try something like

select date_time, refnum from inventory where date_time > to_date('17-FEB-02 12:00:00', 'dd-mon-yy hh24:mi:ss')