Subject Re: [firebird-support] ISC_TIMESTAMP vs. Current Time
Author Ivan Prenosil
> The data type of the field (in the DB) is TIMESTAMP.

But previously you wrote:

> I need to pull two dates from a table and compare them to the current
> time. I keep getting an error that there is an illegal string
> conversion of \"31-MAY-2007\", which is the date in the TIMESTAMP field.
...
> SQLDA1->sqlvar[1].sqldata = (char*) &Start;
> SQLDA1->sqlvar[1].sqltype = SQL_TIMESTAMP;
> SQLDA1->sqlvar[1].sqllen = sizeof(ISC_TIMESTAMP);
...
> // THIS STATEMENT ALWAYS FAILS WITH A CONVERSION ERROR...
> while( 0 == isc_dsql_fetch(STAT1, &STMT1, 1, SQLDA1) )

The error message clearly state you *are* converting from string.
Seems you are still hiding some important info ...