Thank you. I had problem to read it. Meanwhile I found that the oryginal format should be 'dd/MMM/yy h:mm a'. Thank you anyway!
Sent: Tuesday, October 11, 2022 at 2:16 PM From: "Bart Maertens" <[email protected]> To: [email protected] Subject: Re: Ho to convert date in format ‘04/Oct/22 1:24 PM’ to 'normal one'? Hi Mike, The metadata tab in the Select Values transform [1] lets you do exactly that. If you read your data as a date field, convert it to a String with a format like "dd/MM/yyyy hh:mm". If you read your input date as a String in one format and want to convert it to another format, cast it to a date first, using your input format like "dd/MMM/yy hh:mm aa". [1] https://hop.apache.org/manual/latest/pipeline/transforms/selectvalues.html Regards, Bart On Tue, Oct 11, 2022 at 1:56 PM <[email protected][mailto:[email protected]]> wrote:Hello dear HOP creators! Is there any way I can convert date like ‘04/Oct/22 1:24 PM’ to ‘04/10/2022 1:24’ format in Hop? Regards, Mike
