Hi

when i am making a partition of a table base on date time. i am geting result like this

STARTDATE ENDDATE

PARTITION 1 =NULLNULL

PARTITION 2 =2010-03-02 00:02:22.0002010-03-31 23:59:33.000

PARTITION 3 =2010-04-01 00:01:06.0002010-06-30 23:59:22.000

PARTITION 4 =2010-07-01 00:00:40.0002010-09-08 03:25:23.000

SO CAN U PLEASE HELP ME I WANT THE RESULT LIKE THIS:

STARTDATE ENDDATE

PARTITION 1 =2010-03-02 00:02:22.0002010-03-31 23:59:33.000

PARTITION 2 =2010-04-01 00:01:06.0002010-06-30 23:59:22.000

PARTITION 3 =2010-07-01 00:00:40.0002010-09-08 03:25:23.000

PARTITION 4 = NULL NULL