Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
TTH1
Contributor II

Getting date time format is wrong

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 

 

Labels (2)
1 Solution

Accepted Solutions
Arun_Arasu
Support

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

View solution in original post

4 Replies
OritA
Support

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
Specialist III

>>> 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
Contributor II
Author

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
Support

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