oracle query

I have ORacle 9i database. With vb6 I am firing the query-
select * from woc_mas
(woc_dt is date type)
it is returning all the records. but on writing the query-
select * from woc_mas where woc_dt > '01/01/2005'
no records returns

suggest how to query with date field

i think, by the looks of it, u should use the dd/mmm/yyyy format
try

VB Code:

select * from woc_mas where woc_dt > '01/jan/2005'

Try this:
select * from woc_mas where woc_dt > to_date('01/01/2005', 'dd-mm-yyyy')

hi

Format your date as per your database date formate

Moved to database development.