Hi, Alan.

I added a time component, and got the similar error:
illegal string conversion of \"31-MAY-2007
01:00:00.000\"

At this point, can you (or anyone else for that
matter) post a working example??

Thanks.
Kurt.



--- Alan McDonald <alan@...> wrote:

> > Hi.
> >
> > 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.
>
> it's illegal because there's no time component to
> your string.
> add a time component, cast it to timestamp, or use
> DATESTAMP instead.
> Alan
>
> >
> > Below is a code fragment of what I'm attempting to
> do...any advice
> > would be appreciated....
> >
> > Kurt.
> >
> >
> > // SET UP THE FIELDS RETURNED BY QUERY....
> > SQLDA1->sqlvar[0].sqldata = (char *)
> Trends.szMAC;
> > SQLDA1->sqlvar[0].sqltype = SQL_TEXT;
> > SQLDA1->sqlvar[0].sqllen = 32;
> >
> > SQLDA1->sqlvar[1].sqldata = (char*) &Start;
> > SQLDA1->sqlvar[1].sqltype = SQL_TIMESTAMP;
> > SQLDA1->sqlvar[1].sqllen =
> sizeof(ISC_TIMESTAMP);
> >
> >
> > SQLDA1->sqlvar[2].sqldata = (char*) &Stop;
> > SQLDA1->sqlvar[2].sqltype = SQL_TIMESTAMP;
> > SQLDA1->sqlvar[2].sqllen =
> sizeof(ISC_TIMESTAMP);
> > .
> > .
> > .
> > // THIS STATEMENT ALWAYS FAILS WITH A
> CONVERSION ERROR...
> > while( 0 == isc_dsql_fetch(STAT1, &STMT1, 1,
> SQLDA1) )
> > {
> > // COPY THE RESULTS...
> > memset( &Trends, 0, sizeof(Trends) );
> >
> > RightTrim( Trends.szMAC, 32 );
> >
> > // HERE'S WHERE I NEED TO CONVERT TO
> STRUCT TM/TDATETIME...
> > }
> >
> >
> >
> >
>

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

> >
> > Visit http://www.firebirdsql.org and click the
> Resources item
> > on the main (top) menu. Try Knowledgebase and FAQ
> links !
> >
> > Also search the knowledgebases at
> http://www.ibphoenix.com
> >
> >
>

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

> >
> > Yahoo! Groups Links
> >
> >
> >
> >
>
>

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