in reply to Re^8: Issue while inserting Thai Characters into Database..
in thread Issue while inserting Thai Characters into Database..

I now realise you probably mean an actual timestamp column as opposed to a datetime column - yes? timestamp columns are special in SQL Server and you generally cannot insert into them but you can set a DEFAULT on the column to get the current time. If you have a column of type timestamp you should not be inserting into it - if you need to then make it a datetime instead and use the ODBC "ts" syntax.

  • Comment on Re^9: Issue while inserting Thai Characters into Database..

Replies are listed 'Best First'.
Re^10: Issue while inserting Thai Characters into Database..
by ajaykumarb (Initiate) on Jan 22, 2010 at 11:24 UTC
    Sorry for the confusion Martin. Actually it is datetime datatype in SQL Server and i tried inserting a value "2010-01-22 12:00:00 AM" as execute("ts '$bdate'"); but i ended out with Precision error.

      The "AM" is not valid syntax - omit it.