Re: Partition table by date field

(partition p1 value less then (to_date('01-Jan-2000','dd-mon-yyyy')))

or any variation in date formatting you
prefer, provided it uses a 4-digit year, and you may include times if you wish.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

ken k wrote in message ...


>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

>

>

>