Re: [GENERAL] current_timestamp and default now()

1999-10-26 Thread amy cheng
ject. I need to FINISH it TODAY ;-) >From: Charles Tassell <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: Re: [GENERAL] current_timestamp and default now() >Date: Tue, 26 Oct 1999 11:19:32 -0300 > >I believe it works if you put now() in single quotes. EG: >

Re: [GENERAL] current_timestamp and default now()

1999-10-26 Thread Charles Tassell
I believe it works if you put now() in single quotes. EG: create table test ( proposetime datetime not null default 'now()', ) At 10:07 PM 10/25/99, Lincoln Yeoh wrote: >At 01:05 PM 25-10-1999 PDT, amy cheng wrote: > >hi, there, > > > >I'm using: > > > >create table test ( > >propos