Re: Re: Ho to convert date in format ‘04/Oct/22 1:24 PM’ to 'normal one'?

[podunk]

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