I am trying to do a simple query to my Azure Sql db and the date is coming back wrong by 1 day.
The weirdest thing is it is correct sometimes, but not all the time.
If I look in SSMS and do a SELECT * FROM MYTABLE. I see the [filedate] column in question as 2015-08-19. (datatype is date)
THE CORRECT VARIABLE IS 2015-08-19
Now when I run the same query on my desktop program, which accesses a published web service I created, the returned data is 2018-08-18.
For some reason the date is being returned 1 day off.
To add another thing, when I run the web service locally, it returns the correct date.
Does anyone know why this is happening and how to fix this?