<div>
A timestamp is equivalent to a binary(8) column. &nbsp;So you most likely have to convert it to a number first.<br />
<br />
CAST(CAST(tbl_PET_Pet.Pet_<wbr />Time_Updat<wbr />ed as bigInt) as varchar(20)) + tbl_PET_Pet.PET_Pet_Refere<wbr />nce as uniqueid
</div>


A timestamp is equivalent to a binary(8) column.  So you most likely have to convert it to a number first.

CAST(CAST(tbl_PET_Pet.Pet_Time_Updated as bigInt) as varchar(20)) + tbl_PET_Pet.PET_Pet_Reference as uniqueid

<div>
Thanks but that still gives the same error message.
</div>


Thanks but that still gives the same error message.

<div>
I think you need to past the entire query.<br />
<br />
Also, what is the backend database server?
</div>


I think you need to past the entire query.

Also, what is the backend database server?

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am trying to make a unique (but repeatable) reference by concatenating a string with a timestamp as part of an Access 97 query via the Sun ODBC-JDBC connector wit iReport:<br />
<br />
tbl_PET_Pet.Pet_Time_Updat<wbr />ed + tbl_PET_Pet.PET_Pet_Refere<wbr />nce as uniqueid<br />
<br />
The report complains that the textfield cannot be cast from a timestamp to a string so I have tried various permutations in the query, such as:<br />
<br />
cast (tbl_PET_Pet.Pet_Time_Upda<wbr />ted as varchar(20)) + tbl_PET_Pet.PET_Pet_Refere<wbr />nce as uniqueid,<br />
<br />
But the query won't build - Missing Operator.<br />
<br />
Am I getting the syntax wrong for an ODBC query?<br />
<br />
Any ideas?<br />
<br />
Thanks
</div>
</div>


Hi,

I am trying to make a unique (but repeatable) reference by concatenating a string with a timestamp as part of an Access 97 query via the Sun ODBC-JDBC connector wit iReport:

tbl_PET_Pet.Pet_Time_Updated + tbl_PET_Pet.PET_Pet_Reference as uniqueid

The report complains that the textfield cannot be cast from a timestamp to a string so I have tried various permutations in the query, such as:

cast (tbl_PET_Pet.Pet_Time_Updated as varchar(20)) + tbl_PET_Pet.PET_Pet_Reference as uniqueid,

But the query won't build - Missing Operator.

Am I getting the syntax wrong for an ODBC query?

Any ideas?

Thanks

Error trying to CAST a timestamp with sun ODBC-JDBC bridge and ireport

Microsoft Windows XP is the sixth release of the NT series of operating systems, and was the first to be marketed in a variety of editions: XP Home and XP Professional, designed for business and power users. The advanced features in XP Professional are generally disabled in Home Edition, but are there and can be activated. There were two 64-bit editions, an embedded edition and a tablet edition.

Windows XP

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.