WCF Test: Fixed the issue of Zulu Time in Parasoft SOAtest

 If I declare DATE and DATETIME variables, they will display the following date format in SQL Server.  

DECLARE @MyLowDt DATE, @MyHighDt DATETIME

MyLowDt: 2004-02-11

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.

MyHighDt: 2014-02-11T00:00:00.0

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.