Warning for timestamp_from_string

[eze_ke]

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

[DSguru2B]

Try

Code: Select all

StringToTimestamp(in.Date:" 120000","%yyyy%mm%dd %hh%nn%ss") 

[eze_ke]

still i am getting the same warnings

""""Detail_Tfm,0: Conversion error calling conversion routine timestamp_from_string data may have been lost""""

[DSguru2B]

Are you getting that error for each and every row or just a few rows?

[eze_ke]

i am getting 5 warnings
incomming 103631 rows --- > written to Seq file 103631

[craviraj]

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

[DSguru2B]

with my syntax, you do not need any stage variables. The input mask will take care of the input format.