So I have a table in my DB which stores data along with start and end date and time(datatype is datetime). Now, I have defined two inputs to my service which is a query to select certain data where start time and end time are inputs. the baseType is datetime. When i enter the values, im getting the result as no data, but I have given the exact date and time as in the db table.
Solved! Go to Solution.
Something that has bitten me a few times is that when you feed datetime inputs using widgets on a mashup, it uses the local time zone of your browser and then passes in UTC time to the service. Perhaps this is what's up?