different results for dates direct sql quire vs Matlab sql querry

3 vues (au cours des 30 derniers jours)
Yang
Yang le 22 Août 2014
Commenté : José-Luis le 22 Août 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?
  1 commentaire
José-Luis
José-Luis le 22 Août 2014
Please provide a minimum working example illustrating your problem.

Connectez-vous pour commenter.

Réponses (0)

Catégories

En savoir plus sur Dates and Time dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by