Re: SQL: How to select date by month and/or year

raab_at_amsd3c.imib.rwth-aachen.de wrote:
>
> how can I perform a selection of a date-field by any single subfield (day, month, year ...). I tried
>
>select * from test_table where date_field like to_date('01', 'MM')

try this:

        select * from test_table where date_field like '01%'; Received on Tue May 06 1997 - 00:00:00 CDT