Hi all, Just in case you want to reference the java documentation so that you don't have to link to Hitachi's page. https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.htmlhttps://docs.oracle.com/javase/8/docs/api/java/text/DecimalFormat.htmlDiegoSent from my Galaxy -------- Original message --------From: pod...@gmx.com Date: 12/10/22 1:36 am (GMT+10:00) To: users@hop.apache.org Subject: Re: Re: Ho to convert date in format ‘04/Oct/22 1:24 PM’ to 'normal one'? Useful - thank you!
Sent: Tuesday, October 11, 2022 at 2:38 PM From: "christian.gutkne...@bluewin.ch" <christian.gutkne...@bluewin.ch> To: users@hop.apache.org Subject: Re: Re: Ho to convert date in format ‘04/Oct/22 1:24 PM’ to 'normal one'? Hi all For date and time conversion I found this table to be helpful: https://help.hitachivantara.com/Documentation/Pentaho/9.3/Products/Common_Formats Best regards Christian ----Ursprüngliche Nachricht---- Von : bartm...@apache.org Datum : 11/10/2022 - 14:16 (MS) An : users@hop.apache.org Betreff : 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 < pod...@gmx.com> 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