REG: Date format issue

[Anonymous]

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]

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]

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

+ @nthampi 

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

Thanks,

Prabuj

[vapukov]

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