REG: Date format issue

Seven Stars

REG: Date format issue

Hi Team, 

 

I have a column name : 

Timestamp:

13/9/2019 7:00:00 PM

 

Source and target data type i set to date : with a format of "dd/MM/yyyy" tried with "dd/MM/yyyy HH:mm:ss" even string as well

 

When i migrate this data to target db, i am getting the error like :

The cell format is not Date in ( Row. 1 and ColumnNum. 1 )

 

Thanks,

Prabuj

 

 

Forteen Stars

Re: REG: Date format issue

Hi,

 

proper format for your date - "dd/MM/yyyy hh:mm:ss aaa"

 

the good resource for test datetime formats - http://www.sdfonlinetester.info/# 

-----------
Seven Stars

Re: REG: Date format issue

@vapukov I am seeing the same error by using the below format.

 

@nikhilthampi 

 

can you suggest how it can be achieved. Kindly find the attachment of screenshot

 

Capture23.JPGCapture24.JPG

 

Thanks,

Prabuj

Forteen Stars

Re: REG: Date format issue

The more information you provide in the question the faster will be the correct answer! ;-) (you not mentioned Excel in your question)

 

Excel store date time as double number. for the test - define in schema column as string or double and connect direct to tLogRow

you will see - what really came from Excel

something like:

.------------------.
|    tLogRow_1     |
|=----------------=|
|dateColumn        |
|=----------------=|
|43721.791666666664|
'------------------'

you need to use tJavaRow component and look about java.time

I can't find my full code for time part, but date part you can convert from double by :

LocalDate.of( 1899 , Month.DECEMBER , 30 ).plusDays( (row1.dateColumn).longValue() ).toString()

if find my routine, will add it later

-----------

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

The Forrester Wave: Strategic iPaaS and Hybrid Integration Platforms, Q1 2019

Find out how Forrester rate different iPaaS and Hybrid Integration Platforms

Read

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch Now