Date format ambiguity.

13 views
Skip to first unread message

akhil agrawal

unread,
Mar 24, 2020, 7:18:14 AM3/24/20
to diffkit-user
Can anyone tell how to resolve date format ambiguity (mmddyyyy or ddmmyyyy for datediffor())?
like 12-02-2019 can be 12 feb or 2nd december. How does it resolves this ambiguity?So it is data element difference which should be reported (one table may contain 12 feb and other may contain 2 december does it highlight the difference in such a case ,ideally it should).If not ,I need to develop a tool which reports both formatting as well as data element mismatch.Any leads on how dates should be compared?

Reply all
Reply to author
Forward
0 new messages