
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
>>> 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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
