Partition table by date field

Has anyone done this? What is the syntax for entering the date?

create table
...
partition by range(date_field)
(partition p1 value less then (????)
)

Or words to that effect.

Thanks,

Ken Received on Thu Jun 15 2000 - 00:00:00 CDT