I have a varchar value of "02/21/2011 12:54" stored in a temporary SQL Server table.
I am retreiving it this way, in an effort to store it in my permanent table, which is a column with a datetime data type:
ParamByName('@DReceived').Value := StripIT(fieldByName('Date Received').AsString)
When I run it in Delphi... I get this message:
raised exception class EOleException with message 'The conversion of a char data to a datetime data type resulted in an out-of-range datetime value'.
I know that I need to run some kind of string or datetime function to get into my permanent datetime column. Question is... which function would work best? and I need the syntax spelled out for me please. Thanks!