Hi, Ivan.

The table looks like this....
CREATE TABLE TRENDS (
MAC VARCHAR(32) NOT
NULL,
STATE INTEGER NOT NULL,
STARTTIME_STAMP TIMESTAMP,
STOPTIME_STAMP TIMESTAMP
);

> --- Ivan Prenosil <Ivan.Prenosil@...> wrote:
>
> > 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 ...
>

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com