| Author |
Changing a Default TimeStamp field to a DateTime field
|
|
|
| I want to change a column from being a "Default TimeStamp" to just a
DateTime field type.
It was orig. added like this:
alter table messages add SentDateTime DateTime Default TimeStamp
I tried this:
Alter Table Messages Modify SentDateTime DateTime
But it still is behaving as a default timestamp (the column is updated when
any other column is changed)
Any advice appreciated.
-k-
| |
|
| sorry, v9.02/current build
"Kumar" <ddsnospam@maui.net> wrote in message
news:42696299$1@foru
ms-2-dub...
>I want to change a column from being a "Default TimeStamp" to just a
>DateTime field type.
| |
| Erik Anderson 2005-04-22, 8:23 pm |
| Try something like
alter table messages modify SentDateTime default NULL
note that "default timestamp" means to update the field on every update
"default current timestamp" means to populate the field when the row is
created but leave it alone for updates
"Kumar" <ddsnospam@maui.net> wrote in message
news:42696299$1@foru
ms-2-dub...
>I want to change a column from being a "Default TimeStamp" to just a
>DateTime field type.
>
> It was orig. added like this:
> alter table messages add SentDateTime DateTime Default TimeStamp
>
> I tried this:
> Alter Table Messages Modify SentDateTime DateTime
>
> But it still is behaving as a default timestamp (the column is updated
> when any other column is changed)
>
> Any advice appreciated.
> -k-
>
>
| |
|
| thanks!
"Erik Anderson" < erikba@teamworkgroup
.com> wrote in message
news:42698b94$1@foru
ms-1-dub...
> Try something like
>
> alter table messages modify SentDateTime default NULL
|
|
|
|