how to get a date from year, month, day

[jiehuang001]

in a mysql table, there are columns of "the_year", "the_month", "the_day". how to write a query to list records earlier than 1/1/2004. the following doesn't work..

SELECT * FROM event_table where to_date(the_year - the_month - the_date) < ('2004-1-1')

thanks very much.

Jie

[devinemke]

please do not double post