SQL statement to update date

Question

I have a row 1993-08-02 00:00:00.0

and I would like to update a date field in an access table

This is what I have, but it doesn't work.

UPDATE [Table] SET `Birthdate` = '1993-08-02 00:00:00.0' WHERE `ID` = 000

+2

twodayslate 06 May '10 at 13:09

1 answer

Dolph · Accepted Answer · 2010-05-06T13:19:56+0000

Dates are not strings, but one of the following will result in a date:

DATE [Table] SET `Birthdate` = CDate('1993-08-02 00:00:00.0') WHERE `ID` = 000

DATE [Table] SET `Birthdate` = #08/02/1993# WHERE `ID` = 000