different results for dates direct sql quire vs Matlab sql querry

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

Please provide a minimum working example illustrating your problem.

댓글을 달려면 로그인하십시오.

답변 (0개)

카테고리

도움말 센터File Exchange에서 Dates and Time에 대해 자세히 알아보기

질문:

2014년 8월 22일

댓글:

2014년 8월 22일

Community Treasure Hunt

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

Start Hunting!

Translated by