Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 ...Received on Fri Jun 16 2000 - 00:00:00 CDT
>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
>
>
>