cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

The community will undergo maintenance on October 16th at 10:00 PM PDT and will be unavailable for up to one hour.

problem reading datetime input to service which fetches data from db

gourinaik98
8-Gravel

problem reading datetime input to service which fetches data from db

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.

ACCEPTED SOLUTION

Accepted Solutions

Hi,

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

View solution in original post

3 REPLIES 3

Hi Gouri,

 

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

You can refer this resolution 

 

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?

Hi,

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

Announcements


Top Tags