different results for dates direct sql quire vs Matlab sql querry

3 visualizaciones (últimos 30 días)
Yang
Yang el 22 de Ag. de 2014
Comentada: José-Luis el 22 de Ag. de 2014
I run a simple query to pull dates information from SQL Server database. I need the date to be greater or equal to the beginning date and less or equal to the end date.
If I query directly from the SQL database, I have no problem.
If I query from Matlab to pass the script to the SQL server, the results has been shifted for two days. Thus, the minimum date is 2 days before beginning date and the maximum date is two days before the maximum dates.
Is there any reason for that? and how to correct it?

Respuestas (0)

Categorías

Más información sobre Dates and Time en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by