GraphQL Timestamp Difference in Query
I have one issue where I am trying to get the difference in the timestamp from the 2 existing fields from the schema but getting issues which says Error: Invalid number, expected digit but got: “U”. I am trying to convert below sql query part into graphql query.
ROUND(avg(timestampdiff(SECOND, JobStartDateTime, UpdateDateTime)),0) as AvgTime
And once we get the difference can we parse it to valid type of data like datetime? Any suggestions would be greatly appreciated. Thank you
query MyQuery {
MyQuery {
Region
JobStartDateTime
UpdateDateTime
JobStartDateTime-UpUpdateDateTime
}
}
Read more here: Source link