sql - Get date part only of DateTime in comparing dates -

sql - Get date part only of DateTime in comparing dates -

i trying select info table on or before given time in parameter.

this current query:

select expiry_date table1 expiry_date <= :dateparam , expiry_date > sysdate

the problem dates on table info such 14-nov-13 03.01.45.362000000 pm has time part of more 12.00.00.000000000 not beingness returned in result. if come in 14-nov-13 parameter, info 14-nov-13 03.01.45.362000000 pm not beingness returned.

how date part or seek floor function date column in field?

you can either in oracle. trunc works on date times:

where trunc(expiry_date) <= :dateparam , expiry_date > trunc(sysdate)

sql oracle datetime