Put 'NOW' in there if you want the current date and time.
Put 'TODAY' in there if you just want the date of today with no time.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Lee Catlett" <lee@...>
To: <IBObjects@egroups.com>
Sent: Wednesday, December 20, 2000 1:21 PM
Subject: Re: [IBO] INSERT TIMESTAMP??


> Can someone verify the correct way to do this if possible?
>
> INSERT INTO xxxx VALUES ('Store Name',..whatever..., '1', timestamp);
>
> Can't seem to get the timestamp to work
> Lee Catlett
>
>
>
>
>
>