type conversion in timestamp column of teradata

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
s_porkalai
Participant
Posts: 38
Joined: Sun Mar 25, 2007 11:05 pm
Location: chennai

type conversion in timestamp column of teradata

Post by s_porkalai »

hi,
My requirement is to get the current_timestamp with each record in teradata for that i am using the query

"select <col1>,current_timestamp from <table>"

inside the teradata enterperise stage.

when i use view data, it is showing the data correctly. But when i try to run, it is showing the error in next stage(transformer)
"cannot implicitly convert from sring to timestamp"
how to solve this issue. :?:
thanks & Regards
A.S.Porkalai Lakshmi
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Then explicitly convert from string to timestamp.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply