witchblade
Programmer
Hello.
I have coded timestamp fields in a Teradata Database through a querying application so that I can prompt on them.
My code looks like this for the timestamp fields:
(cast(EODS_PRODDB_V.communication_item.LOAD_TMS as timestamp(0)))
Everything was working fine.
Today, I was given a new model to duplicate this procedure.
However, I got the following error on some of the new timestamp fields:
[NCR][Teradata RDBMS]Right truncation of string data.
I know it has something to do with not enough room in that field in the database.
Do you think this is a database issue, or do I need to tweak my code for those fields giving me the error?
![[ponder]](/data/assets/smilies/ponder.gif "[ponder] [ponder]")
I have coded timestamp fields in a Teradata Database through a querying application so that I can prompt on them.
My code looks like this for the timestamp fields:
(cast(EODS_PRODDB_V.communication_item.LOAD_TMS as timestamp(0)))
Everything was working fine.
Today, I was given a new model to duplicate this procedure.
However, I got the following error on some of the new timestamp fields:
[NCR][Teradata RDBMS]Right truncation of string data.
I know it has something to do with not enough room in that field in the database.
Do you think this is a database issue, or do I need to tweak my code for those fields giving me the error?