SELECT (( SUM(AStatistics.PriACD)
+ SUM(AStatistics.PriCTI)
+ SUM(AStatistics.OverACD)
+ SUM(Atatistics.OverCTI)
))
FROM   "CCenter1"."dbo"."AgStatistics" "AgStatistics"
	INNER JOIN "CCenter1"."dbo"."Ag" "Ag" ON "AgStatistics"."AgID"="Ag"."AgId"
	WHERE  ("AgStatistics"."ReportDayDate">={ts '2008-09-11 00:00:00'} --I need the current timestamp - 24hrs
		AND "AgStatistics"."ReportDayDate"<{ts '2008-09-13 00:00:01'}) --I need the current timestamp
		AND "AgMap"."AgFolderIdentity"=9

quote:

---

Originally posted by h4x0rmx

I have a query that I use to create some reports between different day intervals (usually daily reports). It works great, but now I need the query to figure out by itself the current time and the current time minus 24 hrs. In Oracle I use the function SYSDATE. Is there a similar function on SQL Server?
Here's an example query by the way (the original query is way to long and it might just confuse you)

SELECT (( SUM(AStatistics.PriACD)
+ SUM(AStatistics.PriCTI)
+ SUM(AStatistics.OverACD)
+ SUM(Atatistics.OverCTI)
))
FROM   "CCenter1"."dbo"."AgStatistics" "AgStatistics"
	INNER JOIN "CCenter1"."dbo"."Ag" "Ag" ON "AgStatistics"."AgID"="Ag"."AgId"
	WHERE  ("AgStatistics"."ReportDayDate">={ts '2008-09-11 00:00:00'} --I need the current timestamp - 24hrs
		AND "AgStatistics"."ReportDayDate"<{ts '2008-09-13 00:00:01'}) --I need the current timestamp
		AND "AgMap"."AgFolderIdentity"=9

There are 10 kinds of people: those who understand binary and those who don't

---

quote:

---

Originally posted by visakh16


for blue part use
DATEADD(dd,-1,GETDATE())
and for red part use
GETDATE()

---

quote:

---

Originally posted by h4x0rmx

quote:

---

Originally posted by visakh16


for blue part use
DATEADD(dd,-1,GETDATE())
and for red part use
GETDATE()

---

Will that use a "9/18/2008 9:49:31 AM" as a "2008-09-18 09:49:31"? I'm asking because I'm getting a NULL as a result

There are 10 kinds of people: those who understand binary and those who don't

---

quote:

---

Originally posted by visakh16


it will give back your current datetime value
"2008-09-18 09:49:31" for "9/18/2008 9:49:31 AM"
and "2008-09-18 21:49:31" for "9/18/2008 9:49:31 PM"

---

quote:

---

Originally posted by h4x0rmx

quote:

---

Originally posted by visakh16


it will give back your current datetime value
"2008-09-18 09:49:31" for "9/18/2008 9:49:31 AM"
and "2008-09-18 21:49:31" for "9/18/2008 9:49:31 PM"

---

Thanks! It does work, I don't know what I was doing wrong.
I appreciate it!

There are 10 kinds of people: those who understand binary and those who don't

---