topic Int to Date in Talend Studio

Int to Date

_AnonymousUser — Sat, 16 Nov 2024 13:26:40 GMT

Hi,
I've a Excel file with date in format (25791, 25394 ...) (so int for Talend) and i want to convert it into format (11/08/1970, 10/07/1969, ...) (so date for Talend).
Can you help me please ?

Re: Int to Date

Anonymous — Mon, 03 May 2010 17:19:07 GMT

Hello
Convert long type to Date type on tMap
new java.util.Date(long number)
Best regards
Shong

Re: Int to Date

Anonymous — Sun, 24 Apr 2011 12:03:00 GMT

Hello , i tried to use this type of conversion but not working
xception in thread "main" java.lang.Error: java.lang.Error: Unresolved compilation problem:
The method formatDate(String, Date) is undefined for the type TalendDate
at kiteaproject.extractionkt_0_1.extractionKT.tFileInputExcel_1Process(extractionKT.java:1412)
at kiteaproject.extractionkt_0_1.extractionKT.runJobInTOS(extractionKT.java:1586)
at kiteaproject.extractionkt_0_1.extractionKT.main(extractionKT.java:1457)
Caused by: java.lang.Error: Unresolved compilation problem:
The method formatDate(String, Date) is undefined for the type TalendDate
disconnected
at routines.system.FormatterUtils.format_Date(FormatterUtils.java:21)
at kiteaproject.extractionkt_0_1.extractionKT.tFileInputExcel_1Process(extractionKT.java:1288)
... 2 more
Job extractionKT ended at 10:59 24/04/2011.

Re: Int to Date

Anonymous — Sun, 24 Apr 2011 13:15:03 GMT

Hello,
it seems the field you are passing is defined as String in your flow, not as Integer.
If so you should convert it from String to int first

Re: Int to Date

Anonymous — Tue, 26 Apr 2011 10:08:04 GMT

here is my painful problem,
when i convert from string to int
the output cells relative to date is 01-01-1970.
thanks

Re: Int to Date

Anonymous — Wed, 27 Apr 2011 05:28:05 GMT

when i convert from string to int

How do you convert string to integer/int now?
Best regards
Shong

Re: Int to Date

Anonymous — Wed, 27 Apr 2011 12:39:47 GMT

i use tcovert to conevrt string to integer and after i use tmap to convert integer to date
thanks