Re: [SQL] DEFAULT TEXT 'now'

On Tue, 23 Mar 1999, Roberto Joao Lopes Garcia wrote:

> Hi
>
> I�m have a table like bellow:
>
> CREATE TABLE conex (
>     id int4 PRIMARY KEY DEFAULT NEXTVAL('seq_conex'),
>
>     inicio datetime DEFAULT TEXT 'now',
>     ultimo datetime DEFAULT TEXT
> 'now',
>                  .
>                  .
>                  .
> )
>
> insert into conex (ip) values(�200.200.200.200�)
>
> Will result every time the same data and time for �inicio� and �ultimo�!
>
> I want to insert the current date and time. Is that code correct and the
> result a bug???
> Is there an way to make the DEFAULT work???

try:

...
inicido DATETIME DEFAULT NOW(),
ultimo  DATETIME DEFAULT NOW(),
...

---
Howie <caffeine@toodarkpark.org>   URL: http://www.toodarkpark.org
  "You can change the world with a bullet in the right place"