oracle query

[yesfriends]

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

[mebhas]

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

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

[Frans C]

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

[mvirendra]

hi

Format your date as per your database date formate

[Hack]

Moved to database development.