AdoQuery1.Close;
 AdoQuery1.SQL.Clear;
 AdoQuery1.SQL.Text:='update polldata set clock2= convert(datetime,' #39 MyClock2 #39 ') where emp_no=' #39 Colums[4] #39 
                                                 ' and date=' #39 MyDate #39 ' and clock=' #39 MyClock #39;
AdoQuery1.ExecSQL;

引言: 請問為何會出現字元(char)字串轉換到datetime的語法錯誤訊息

引言:CAST and CONVERT Explicitly converts an expression of one data type to another. CAST and CONVERT provide similar functionality. Syntax Using CAST: CAST ( expression AS data_type ) Using CONVERT: CONVERT ( data_type [ ( length ) ] , expression [ , style ] ) Arguments expression Is any valid Microsoft® SQL Server™ expression. For more information, see Expressions. data_type Is the target system-supplied data type, including bigint and sql_variant. User-defined data types cannot be used. For more information about available data types, see Data Types. length Is an optional parameter of nchar, nvarchar, char, varchar, binary, or varbinary data types. style Is the style of date format used to convert datetime or smalldatetime data to character data (nchar, nvarchar, char, varchar, nchar, or nvarchar data types), or the string format when converting float, real, money, or smallmoney data to character data (nchar, nvarchar, char, varchar, nchar, or nvarchar data types).

 AdoQuery1.Close;
 AdoQuery1.SQL.Clear;
 AdoQuery1.SQL.Text:='update polldata set clock2= convert(datetime,' #39 MyClock2 #39 ') where emp_no=' #39 '001' #39                                                  ' and date=' #39 MyDate #39 ' and clock=' #39 MyClock #39;
AdoQuery1.ExecSQL;

引言: 我資料庫是sql mycolock2,mydate,myclock是字串型態的變數