Partition error

• balbirsinghsodhi

  SSCrazy Eights

  Points: 9210

  More actions

  January 4, 2010 at 12:11 pm

  #156547

  When I try to run following command, I get error. Partition field is a datetime and also checked the data, all the data has datetime value.

  ALTER PARTITION FUNCTION PFCLHFunction()

  SPLIT RANGE ('2010-06-31 23:59:59.997')

  GO

  Msg 7705, Level 16, State 2, Line 1

  Could not implicitly convert range values type specified at ordinal 1 to partition function parameter type.

  any idea. ?

• balbirsinghsodhi

  SSCrazy Eights

  Points: 9210

  More actions

  January 4, 2010 at 12:15 pm

  #1098568

  It's fixed. the day is wrong. it should be 30 not 31.

  ALTER PARTITION FUNCTION PFCLHFunction()

  SPLIT RANGE ('2010-06-30 23:59:59.997')

  GO