You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@hop.apache.org by po...@gmx.com on 2022/10/11 11:56:22 UTC
Ho to convert date in format ‘04/Oct/22 1:24 PM’ to 'normal one'?
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
Re: Ho to convert date in format ‘04/Oct/22 1:24 PM’ to 'normal one'?
Posted by po...@gmx.com.
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" <ba...@apache.org>
To: users@hop.apache.org
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 <podunk@gmx.com[mailto:podunk@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
Re: Re: Ho to convert date in format ‘04/Oct/22 1:24 PM’ to 'normal one'?
Posted by po...@gmx.com.
Useful - thank you!
**Sent:** Tuesday, October 11, 2022 at 2:38 PM
**From:** "christian.gutknecht@bluewin.ch" <ch...@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
> \----Ursprungliche Nachricht----
> Von : bartmaer@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 < podunk@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
>
>
>
>
> 
>
>
Re: Re: Ho to convert date in format ‘04/Oct/22 1:24 PM’ to 'normal one'?
Posted by "christian.gutknecht@bluewin.ch" <ch...@bluewin.ch>.
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 : bartmaer@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 <
podunk@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
Re: Ho to convert date in format ‘04/Oct/22 1:24 PM’ to 'normal one'?
Posted by Bart Maertens <ba...@apache.org>.
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 <po...@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
>
>
>