Hi
I did a search with the error in the forum but could not resolve the issue
Warning:--Detail_Tfm,0: Conversion error calling conversion routine timestamp_from_string data may have been lost
Ora----->Tfm------>seq
I am extracting from Oracle view and writing to a sequential file
One of the date field in Oracle is defined as varchar(8) (20071109)
When I am trying to convert it to time stamp (%yyyy-%mm-%dd %hh:%nn:%ss) i am getting the following error
""" Detail_Tfm,0: Conversion error calling conversion routine timestamp_from_string data may have been lost """
In the Stage Variable:-
StringToTimestamp(((LOT_Daily_Read_Lnk.STRING_DT[1,4]:'-':LOT_Daily_Read_Lnk.STRING_DT[5,2]:'-':LOT_Daily_Read_Lnk.STRING_DT[7,2]) : " 00:00:00") ,"%yyyy-%mm-%dd %hh:%nn:%ss")
Please Suggest
Appreciate Your Help
Thanks
MAM
Warning for timestamp_from_string
Moderators: chulett, rschirm, roy
Warning for timestamp_from_string
Thank
eze
eze
Try
Code: Select all
StringToTimestamp(in.Date:" 120000","%yyyy%mm%dd %hh%nn%ss")
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
String To TimeStamp
Hi eze_ke,
May be space is missing between date and hours while giving the syntax:
StringToTimestamp(stg1,"%yyyy-%mm-%dd %hh:%nn:%ss")
I had used 2 stage variables as given by you:
stg1 = stg[1,4]:"-":stg[5,2]:"-":stg[7,2]:" 00:00:00"
stg = '20071109'
..and the job ran without errors.
~ R-Square
May be space is missing between date and hours while giving the syntax:
StringToTimestamp(stg1,"%yyyy-%mm-%dd %hh:%nn:%ss")
I had used 2 stage variables as given by you:
stg1 = stg[1,4]:"-":stg[5,2]:"-":stg[7,2]:" 00:00:00"
stg = '20071109'
..and the job ran without errors.
~ R-Square