String to Timestamp conversion

[agathaeleanor]

I have gone through the forum topic posted for topic string to timestamp conversion. Knew that I should follow the source data format,

input data: 20100801093010
derivation: StringToTimestamp(Trim(Lnk_InValidation.TIMESTAMP),"%yyyy%mm%dd%hh%nn%ss")

I am still getting error,
Data string '20100801093010' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss': an integer was expected to match tag %nn.

Need your help in this matter.

[chulett]

I'm unclear how you can be saying that you are using "%yyyy%mm%dd%hh%nn%ss" in your function call and yet the error message shows "%yyyy-%mm-%dd %hh:%nn:%ss"... can you double-check, please?

[agathaeleanor]

Yes, confirmed that error message is expecting format '%yyyy-%mm-%dd %hh:%nn:%ss'

However, right before the error message, there is a warning saying,

SEQ_LU_ROUTE: When validating import schema: Unrecognized top level format property: timestamp_format="%yyyy-%mm-%dd %hh:%nn:%ss"

Would this cause by any setting in the sequential file?

[manoj_23sakthi]

I'm unclear how you can be saying that you are using "%yyyy%mm%dd%hh%nn%ss" in your function call and yet the error message shows "%yyyy-%mm-%dd %hh:%nn:%ss"... can you double-check, please?

convert string to timestamp

[agathaeleanor]

This has been resolved when i found that the reject link is expecting a timestamp. When i change the datatype to varchar in reject link, it works fine.