topic Re: [resolved] Unix date to normal date (tmap) in Talend Studio

[resolved] Unix date to normal date (tmap)

_AnonymousUser — Sat, 16 Nov 2024 14:00:13 GMT

I have a Unix date and want to convert it to a normale Date
for example: 13959.583 -> what will be 21.03.2008 13:59:31

can anyone help me?
Thanks Florian

Re: [resolved] Unix date to normal date (tmap)

Anonymous — Thu, 09 Apr 2009 04:22:40 GMT

Hello
Using the following code:

new java.util.Date((long)(row1.unixDate*1000))

Input file:

13959.583
123451254
232012.2132

Result:

Starting job test at 11:17 09/04/2009.
.-------------------.
|     tLogRow_1     |
|=-----------------=|
|date               |
|=-----------------=|
|01.01.1970 11:52:39|
|30.11.1973 04:00:54|
|04.01.1970 00:26:52|
'-------------------'
Job test ended at 11:17 09/04/2009.

Best regards

shong

Re: [resolved] Unix date to normal date (tmap)

_AnonymousUser — Thu, 09 Apr 2009 07:31:22 GMT

Hello, thanks for that help, my Unix date is a float, can you help me please?
It's called SOLL_START Type: float length: 15 precision:10
It is possible to convert that to Double

Re: [resolved] Unix date to normal date (tmap)

Anonymous — Thu, 09 Apr 2009 07:43:03 GMT

Hello friend
You only need to select fload to replade double when defining the schema.
Best regards

shong

Re: [resolved] Unix date to normal date (tmap)

Anonymous — Thu, 09 Apr 2009 08:08:36 GMT

That are my Unix Dates in float:
13959.583
13964.261
13958.415
And that is, what I get as date:
01.01.1970 04:52:39
01.01.1970 04:52:44
01.01.1970 04:52:38
And it should be:
21.03.2008 13:59:31
26.03.2008 06:15:50
20.03.2008 09:57:36
So, I need some help please
Thanks Florian

Re: [resolved] Unix date to normal date (tmap)

Anonymous — Thu, 09 Apr 2009 08:26:18 GMT

Hello
If the unix Dates is 13959.583, the really human date shoule be: 01.01.1970 04:52:39, you can convert it on website: http://www.epochconverter.com/
I wonder how do you convert it to 21.03.2008 13:59:31 with other tools or is there some relationship between 13959.583 and 21.03.2008 13:59:31?
Best regards

shong

Re: [resolved] Unix date to normal date (tmap)

Anonymous — Thu, 09 Apr 2009 08:35:18 GMT

Ok, I asked a developer at my company and he had a java class for me, so thanks for your help