Date is changing from a one day.
-
hi all, We are requesting for data from SQL Server which is in a server(it is in London).The requested stored Procedure has TWO DateTime Variables.(@startdate DATETIME,@enddate DATETIME) So when we doing request with StartDate='23/09/2006' AND EndDate='29/09/2006' , startdate is converted to '24/09/2006' and enddate is converted to '30/09/2006'. Then request result is completed wrong. Can anyone please tell me why it happens? I do not change datetime when processing.It is happen automatically. thanks in advance.
-
hi all, We are requesting for data from SQL Server which is in a server(it is in London).The requested stored Procedure has TWO DateTime Variables.(@startdate DATETIME,@enddate DATETIME) So when we doing request with StartDate='23/09/2006' AND EndDate='29/09/2006' , startdate is converted to '24/09/2006' and enddate is converted to '30/09/2006'. Then request result is completed wrong. Can anyone please tell me why it happens? I do not change datetime when processing.It is happen automatically. thanks in advance.
:) select getutcdate() select getdate()