• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » [resolved] conversion between Date type and Datetime type

#1 2010-03-30 12:32:14

aymen.bs
Member
Company: Proxym-it
Registered: 2010-02-22
Posts: 40
Website

[resolved] conversion between Date type and Datetime type

hello,
in the source table the data type is Datetime  'yyyy-mm-dd hh:mm:ss'
however,in the destination table the data type is Date 'yyyy-mm-dd'
How may i make the integration?
regards

Offline

#2 2010-03-30 12:47:45

aymen.bs
Member
Company: Proxym-it
Registered: 2010-02-22
Posts: 40
Website

Re: [resolved] conversion between Date type and Datetime type

any help will be appriciated.
thanks in advance

Offline

#3 2010-03-30 15:19:38

aymen.bs
Member
Company: Proxym-it
Registered: 2010-02-22
Posts: 40
Website

Re: [resolved] conversion between Date type and Datetime type

it's possible to make the data integration between this two types with TOS??
regards

Offline

#4 2010-03-30 15:38:45

aymen.bs
Member
Company: Proxym-it
Registered: 2010-02-22
Posts: 40
Website

Re: [resolved] conversion between Date type and Datetime type

what about using: TalendDate.formatDate()
So can someone tell me please how to use TalendDate.formatDate?
and what should i write in the parameter list??
thanks

Offline

#5 2010-03-30 16:30:51

aymen.bs
Member
Company: Proxym-it
Registered: 2010-02-22
Posts: 40
Website

Re: [resolved] conversion between Date type and Datetime type

i changed the data types in the source table and the destination table into String and it works!

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » [resolved] conversion between Date type and Datetime type

Board footer

Powered by FluxBB