Is this a bug? This Alter doesn't work and I have no idea how else I can add a default to an Interval column.

ALTER TABLE "VideoList"
ALTER COLUMN "DurationTime" AS Interval Day To Second DEFAULT Interval Day To Second '0 00:00:00'

This give this error:
"ElevateDB Error #700 An error was found in the statement at line 2 and column 72 (Expected interval constant but instead found Day)"

Rolf,

<< Is this a bug? This Alter doesn't work and I have no idea how else I can add a default to an Interval column.

ALTER TABLE "VideoList"
ALTER COLUMN "DurationTime" AS Interval Day To Second DEFAULT Interval Day To Second '0 00:00:00' >>

What you want is this:

INTERVAL 'D H:M:S' DAY TO SECOND

so the ALTER TABLE statement would be:

ALTER TABLE "VideoList"
ALTER COLUMN "DurationTime" AS Interval Day To Second DEFAULT Interval '0 00:00:00' Day To Second

Tim Young
Elevate Software
www.elevatesoft.com

Tim

Thank you.

Regards
Rolf