karengibbs
Occasional Contributor
Joined 7 years ago
User Profile
User Widgets
Contributions
Re: Date comparisons in different formats
I have no control over how the date is inserted into the dB. As a tester for one of the features developed by an API development team, I need to confirm that the submitted date (which must be sent in the ISO 8601 Standard format with the T and Z as part of the string as described in my original question) is the same as the date and time that was inserted into the dB, however the date was modified into a string without the T and Z and my test assertion fails because it is not EXACTLY the same as what was sent. So I am trying to learn how to convert one or the other of the date strings so my compare is successful.4.2KViews0likes1CommentRe: Date comparisons in different formats
Your clarification question below is correct - I am trying to check if the date submitted is the same as the date that was pulled from the MySQL dB; so either I need to find out how to do the conversion the same way that was done for the dB resulting in the string retrieved so I can compare that they are the same ... OR I need to find out how to convert the retrieved string into the same format as was sent in the original request with the T and Z as part of the string.4.2KViews0likes0CommentsDate comparisons in different formats
I am trying to compare dates sent to MySQL in ISO 8601 compliant format, i.e. "2018-12-31T12:59:59Z" that are retrieved from the dB column as "2018-12-31 12:59:59.0" using Groovy; however, I don't know how, or which date, I should convert to do the comparison. Any suggestions would be greatly appreciated. Thanks in advance!Solved4.8KViews0likes10Comments