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.6 years agoPlace ReadyAPI QuestionsReadyAPI Questions4.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.6 years agoPlace ReadyAPI QuestionsReadyAPI Questions4.2KViews0likes0CommentsDate comparisons in different formats
I am trying to compare dates sent to MySQLin 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!Solved6 years agoPlace ReadyAPI QuestionsReadyAPI Questions4.5KViews0likes10Comments