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.
String to Timestamp conversion
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 76
- Joined: Mon Mar 05, 2007 9:26 pm
- Location: Malaysia
-
- Participant
- Posts: 76
- Joined: Mon Mar 05, 2007 9:26 pm
- Location: Malaysia
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?
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?
-
- Participant
- Posts: 47
- Joined: Tue Feb 23, 2010 12:16 am
- Location: CHENNAI
-
- Participant
- Posts: 76
- Joined: Mon Mar 05, 2007 9:26 pm
- Location: Malaysia