different results for dates direct sql quire vs Matlab sql querry

Yang

2014 8 22

0 个回答

3 次查看（30 天）

0 个投票

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?