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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
