topic Re: Getting date time format is wrong in Qlik Replicate

Getting date time format is wrong

TTH1 — Thu, 15 Jun 2023 07:46:30 GMT

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

Re: Getting date time format is wrong

OritA — Thu, 15 Jun 2023 07:55:42 GMT

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

Re: Getting date time format is wrong

Heinvandenheuvel — Thu, 15 Jun 2023 21:01:13 GMT

>>> 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.

Re: Getting date time format is wrong

TTH1 — Fri, 16 Jun 2023 05:38:43 GMT

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

Re: Getting date time format is wrong

Arun_Arasu — Fri, 16 Jun 2023 06:24:30 GMT

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