Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 2 of 2 total

Wed, Sep 27 2006 8:36 AM	Permanent Link
Mike Mayer	Hi, Why sql below does not work? I get error that default "CURRENT_TIMESTAM" expression is set incorectly - 11949 ALTER TABLE "document" ADD COLUMN if not exists "InsertDate" TIMESTAMP DEFAULT CURRENT_TIMESTAM; Mike
Wed, Sep 27 2006 9:18 AM	Permanent Link
Arnd Baranowski	May be, because you forgot the "P" at the end of "CURRENT_TIMESTAM" Arnd Mike Mayer wrote: > Hi, > > Why sql below does not work? I get error that default "CURRENT_TIMESTAM" expression is set incorectly - 11949 > > ALTER TABLE "document" ADD COLUMN if not exists "InsertDate" TIMESTAMP DEFAULT CURRENT_TIMESTAM; > > Mike >