Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
wshtrue
Yak Posting Veteran
74 Posts |
Posted - 2006-08-26 : 13:37:47
|
Hi Guys,Your help will be greatly appreciated. OK now my question is that we are using SQL Server 2000 and we are using Microsoft Report Manager as a Reporting tool.It has too text boxes labeled as Start Date and End Date. Let us say that I enter 07/10/2006 in Start Date and 07/10/2006 in End Date. When my report is executed it displays 07/10/2006 12:00 AM and 07/10/2006 12:00 AM in the End Date. IS IT CORRECT? Actually I want report to display me all transactions according to GMT Time so Please help me in understanding that What time should It show in Start Date and End Date and I should be getting transactions from what time to what time if my Start Date and End Date is entered 07/10/2006 12:00AM.Right now it is displaying me transactions for 07/10/2006 10:AM to 9:59PM of 07/11/2006. IS IT CORRECT?Now if I enter 07/11/2006 in Start Date and End Date then please tell me should I be seeing any transactions of 07/11/2006 which were displayed when I had entered 07/10/2006 in Start Date and End DateYour help will be greatly appreciated. Thanks |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-04 : 06:11:53
|
There is no way to tell GMT time, unless the transactions made contains information about time zone.And in your query, useselect * from whatever WHERE someDatecolumn >= DATEADD(day, DATEDIFF(day, 0, @StartDate), 0) and someDatecolumn < DATEADD(day, DATEDIFF(day, 0, @StartDate), -1) Peter LarssonHelsingborg, Sweden |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-09-04 : 09:22:41
|
The function GetUTCDate() returns Universal Time Coordinate or GMT) as per BOL. Check whether it can be of any help !Harsh AthalyeIndia."Nothing is Impossible" |
|
|
|
|
|
|
|