Skip to main content
G
gourinaik981-Visitor
1-Visitor
February 26, 2020
Solved

problem reading datetime input to service which fetches data from db

  • February 26, 2020
  • 3 replies
  • 1545 views

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.

Best answer by gourinaik98

Hi,

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

3 replies

T
TanmeyTWX17-Peridot
17-Peridot
February 26, 2020

Hi Gouri,

 

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

You can refer this resolution 

 

E
eliotlandrum14-Alexandrite
14-Alexandrite
February 26, 2020

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?

G
gourinaik981-VisitorAuthorAnswer
1-Visitor
March 3, 2020

Hi,

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

Terms & ConditionsAccessibility statement