problem reading datetime input to service which fetches data from db

[gourinaik98]

Hello,

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.

[TanmeyTWX]

Hi Gouri,

Did you parse the start/end datetime as an input?

You can refer this resolution 

[eliotlandrum]

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?

[gourinaik98 · Accepted solution]

Hi,

the format was wrong actually. I used the format function to get it right.