Subject | Re: [firebird-support] ISC_TIMESTAMP vs. Current Time |
---|---|
Author | Ivan Prenosil |
Post date | 2007-05-06T19:47:19Z |
> 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...The error message clearly state you *are* converting from string.
> while( 0 == isc_dsql_fetch(STAT1, &STMT1, 1, SQLDA1) )
Seems you are still hiding some important info ...