selectQuery() date and datetime fields format appear to have

Posted by mopfer on 13-Jan-2014 13:26

In Rollbase 2.0.0.3 both date and date-time fields showed the "2014-01-13 00:00:00.000" format in the results from selectQuery() SOAP API call.  In Rollbase 2.1.0.0 both date and date-time fields show the "Mon Jan 13 00:00:00 EST 2014".  So the formats are consistent across the two data types, but the format changed between Rollbase versions.  As a result, the code that we are using to convert the dates in the results into strings that sort correctly and can be used for date comparisons in ABL no longer work correctly

Is the date format of selectQuery() results something we can configure?  If not, is there a format that we can rely on staying the same going forward?

All Replies

Posted by Sharavan Kumar on 15-Jan-2014 04:36

We have observed this issue already , and it is fixed . It will be available in next hotfix release.

Posted by Bill Wood on 15-Jan-2014 04:53
You did not fully explain what is fixed. Will the hot fix return to the 2.0.0.3 behavior?=
Posted by Sharavan Kumar on 15-Jan-2014 05:08

Yes, it will be reverted to 2.0.0.3 behavior . The fix is that , selectQuery SOAP API Call for both date and date-time fields will now return the value in this format '2014-01-13 00:00:00.000'  instead of "Mon Jan 13 00:00:00 EST 2014".  

Posted by wweultjes on 03-Nov-2015 02:34

Hmm strange in 3.2.5 it is like Mon Jan 13 00:00:00 EST 2014

This thread is closed