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]> 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 > > >
