Getting date time format is wrong

[TTH1]

Hi All,

I have added audit column (insertdate/updatedate) in global rules. however once the data loaded date showing as below

(12/31/9999 11:59:59 PM)

year suppose to be 2023. While checking the in expression it's showing correct date time format.

strftime('%d-%m-%Y %H:%M:%S', 'now')

Please help 

[OritA]

Hi, 

In general Replicate uses in transformation rules sqlite functions.  For further troubleshooting the cause of the problem. Please open a case  and attache to the case the task diagnostic package so we can review your rule setting and endpoint type and better understand what is causing the problem . 

Thanks & regards,

Orit

[Heinvandenheuvel]

>>> it's showing correct date time format.  strftime('%d-%m-%Y %H:%M:%S', 'now')

Nonsense. You specify a format you like but which is meaningless to Replicate. Don't specify anything! Just datetime now.

[TTH1]

Thanks for the response,

Why I have specified the date format as   strftime('%d-%m-%Y %H:%M:%S', 'now') i need output should be

dd-mm-yyyy hh:mm:ss format 

[Arun_Arasu · Accepted solution]

Hi @TTH1 ,

I was just performing some random testing and was able to see the same behavior .

Then I changed the column datatype to String  and  and  applied the same transformation  strftime('%d-%m-%Y %H:%M:%S', 'now')

Now I could see the value as "16-06-2023 06:19:45"

Regards

Arun