If I declare DATE and DATETIME variables, they will display the following date format in SQL Server.
DECLARE @MyLowDt DATE, @MyHighDt DATETIME
MyHighDt: 2004-02-11 00:00:00.000
In SOAtest, if I get (MyLowDt) DATE variable from SQL query and use it in WCF method, the interesting part is that SOAtest uses Zulu time as an input and never returns the rows I want to see.
MyLowDt: 2004-02-11T08:00:00.000Z (Zulu Time)
If I get (MyHighDt) DATETIME variable from SQL query and use it in WCF method, SOAtest uses Timestamp with T as an input and can return the rows I want to see.
In SQL Server, If I use Zulu time to query the data, I can still get the data back.
Open WCF test Client , input Zulu time and I can get the data back.
But in SOAtest, input Zulu time and I can’t get the data back.
Parasoft SOAtest, you should make testing life easier.