You are not logged in.
I've got another problem with dates. Into my tMap I managed to parse a date from a string, the tMap input is like this (String type):
I parse the date with this operation :
(row2.dateheure.equals(""))? null : TalendDate.parseDate("yyyy-MM-dd'T'HH:mm:ss.SSS'Z'",row2.dateheure)
And here is what I've got as output (Date type):
Sun Jun 21 15:57:01 CEST 2009
And in my postgresql database (timestamp with time zone type) :
Well that's half good I retrieve the date partially, how can I do to also get hours, minutes, seconds ?
I've got a file delimiter as input. I retrieve the date as String type, I can't link any pattern to a string. It's only in the tMap tool that I transform this string into a date type with talend.parseDate function.
And I've also set the tMap output and tPostgreSQLOutput with the correct pattern, I still got the hours, minutes, seconds missing into the database.