Re: [SQL] DEFAULT TEXT 'now'

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

> Hi
>
> Im 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(at)toodarkpark(dot)org> URL: http://www.toodarkpark.org
"You can change the world with a bullet in the right place"