In SQL Server use
INSERT INTO TableS
VALUES(GETDATE(),'1','2','3')
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, 20 July 2001 12:53
> To: Multiple recipients of list database
> Subject: [DUG-DB]: Insert Date
>
>
> Hi all,
>
> How to specify a date inserting the current date in a record
> using an SQL ?
>
> The following command generates the message "Invalid keyword".
>
>
> INSERT INTO TableS
> VALUES(DATE,'1','2','3')
>
>
> Note that the table field types are: Date, integer, integer, integer.
>
> TIA
>
> John
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
