different results for dates direct sql quire vs Matlab sql querry

3 次查看（过去 30 天）
Yang
Yang 2014-8-22
评论： José-Luis 2014-8-22
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?

请先登录，再回答此问题。

回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by