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 : [email protected]
Datum : 11/10/2022 - 14:16 (MS)
An : [email protected]
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 <
[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
