topic Re: REG: Date format issue in Talend Studio

REG: Date format issue

Anonymous — Sat, 16 Nov 2024 04:37:52 GMT

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

vapukov — Thu, 19 Sep 2019 10:51:23 GMT

Hi,

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

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

Anonymous — Fri, 20 Sep 2019 05:24:01 GMT

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

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

Thanks,

Prabuj

vapukov — Fri, 20 Sep 2019 07:09:56 GMT

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