GitHub user maxbobse added a comment to the discussion: Select transform returns NullPointerException when converting timestamp from String to Timestamp
I believe the main issue here is that depending on how you use the date format, it can cause problems: You use the date format to convert an existing timestamp value to a string. Here you can basically do anything because there is no validation so 'MM/dd/yyyy HH:mm:ss aa' is a valid format. Hop does not care if the outputted string is nonsense or not. You use the date format to convert a string to a timestamp. Here the format has to be correct, otherwise you get an error as shown above. Also when parsing a string to create a timestamp, the logic is different: 6 and 06 are both accepted values for an hour if you use 'h'. If you export to a string, 'h' produces 6 while 'hh' produces 06. Formatting can be so much fun ... :D GitHub link: https://github.com/apache/hop/discussions/5948#discussioncomment-14880540 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected]
