Larry - What I needed was the correct syntax of the UPDATE statement - thanks!
Sami -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Lustig Sent: Monday, February 07, 2005 11:03 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: SQL DATETIME vs R:BASE DATE > This results in the error message, > "Cannot convert a DATE value to a DATETIME value." That's a surprise! Could you do: ALTER TABLE Table ADD COLUMN NewColumn DATETIME UPDATE Table SET NewColumn = (DATETIME(OldColumn, '0:00 pm')) ALTER TABLE DROP COLUMN OldColumn ALTER TABLE ALTER COLUMN NewColumn TO OldColumn DATETIME You'd have to fiddle with the format of the time in the DATETIME function. -- Larry
