topic Re: converting to unix timestamp for mysql in Talend Studio

converting to unix timestamp for mysql

Anonymous — Sat, 16 Nov 2024 14:16:03 GMT

in a tmap i have to convert something like "02.08.08" into a unix timestamp to store it in a mysql database. can anybody give me a hint how to do that? i am quite new to java.
many thanks...

Re: converting to unix timestamp for mysql

Anonymous — Tue, 05 Aug 2008 02:40:59 GMT

Hello
Set the data type as String for this column, then parse a string to a date.
Best regards
shong

Re: converting to unix timestamp for mysql

Anonymous — Tue, 05 Aug 2008 10:54:09 GMT

thanks but it does not give the right result:
i have :
02.08.2008 (string)
and i need to store:
1217635200 (long)
this is the result of:
long epoch = new java.text.SimpleDateFormat ("dd/MM/yyyy HH:mm:ss").parse("01/01/1970 01:00:00");
but i cannot use this expression in tmap as expression
any idea?
regards
....

Re: converting to unix timestamp for mysql

Anonymous — Wed, 06 Aug 2008 04:08:04 GMT

Hello
On tMap, try

(TalendDate.parseDate("dd.MM.yyyy",row1.date)).getTime()

Best regards

shong