Dealing with Daylight Savings Time / SQL in XQuery Assertion
Hey All,
I'm currently dealing with a test that is looking for a specific time stamp that is defined in the Assertion. However, half the year this test will fail because the assertion's time stamp is a specific yyyy-mm-dd hh:mm:ss.x time the daylight savings time is going to push the hour (hh) off by an hour every half year.
Two questions:
1. Any simple solutions to this?
2. I was looking at trying to place a SQL Query into the assertion, but I'm not even sure if it's possible (below is my attempt at writing the query):
<MSG_TIMESTAMP>sql.execute ("select MSG_TIMESTAMP from ODE_MSG_HEADER where MSG_CORRELATIONID = '${#TestCase#CORRELATION_ID}'")</MSG_TIMESTAMP>
Thanks for the help in advance!
I'm currently dealing with a test that is looking for a specific time stamp that is defined in the Assertion. However, half the year this test will fail because the assertion's time stamp is a specific yyyy-mm-dd hh:mm:ss.x time the daylight savings time is going to push the hour (hh) off by an hour every half year.
Two questions:
1. Any simple solutions to this?
2. I was looking at trying to place a SQL Query into the assertion, but I'm not even sure if it's possible (below is my attempt at writing the query):
<MSG_TIMESTAMP>sql.execute ("select MSG_TIMESTAMP from ODE_MSG_HEADER where MSG_CORRELATIONID = '${#TestCase#CORRELATION_ID}'")</MSG_TIMESTAMP>
Thanks for the help in advance!