Pages: 1

Post reply

  • Index
  •  » Talend Open Studio for Data Integration » Installation
  •  » Change Date

#1 2006-10-16 17:20:25

xavier
New member
Company: Nice - France
Registered: 2006-10-09
Posts: 6

Change Date

I have a date in this format 'dd/mm/yyyy' and i would like in this format 'yyyy-mm-dd'. How can i do ?

Offline

#2 2006-10-16 17:53:40

plegall
Member
Registered: 2006-09-19
Posts: 1586
Website

Re: Change Date

In a tPerlRow:

Code:

$row[column] = join(
    '-',
    (split '/', $row[column])[2,1,0]
);

Offline

#3 2006-10-16 18:08:53

plegall
Member
Registered: 2006-09-19
Posts: 1586
Website

Re: Change Date

Or more readable:

Code:

my ($dd, $mm, $yyyy) = split '/', $row[column];
$row[column] = join('-', $yyyy, $mm, $dd);

Offline

#4 2006-10-17 09:47:03

xavier
New member
Company: Nice - France
Registered: 2006-10-09
Posts: 6

Re: Change Date

thanks

Offline

Post reply

Pages: 1

  • Index
  •  » Talend Open Studio for Data Integration » Installation
  •  » Change Date

Board footer

Powered by FluxBB