On Sun, 6 Oct 2002, Brian Ward wrote:
> How do I create a time stamp column in a table that default to the current
> time
> when a row is inserted?
> I tried putting in now() as the default but I have something wrong
> with the syntax or something I think
> Any one have an example of a table creation script that has a timestamp
> column?
When you have an example which does not do what you want, it is better to
provide that so we can see how to correct it.
I am using : firstlogin timestamp default current_timestamp