quote:

---

Originally posted by aoriju

how to set todays maximum timestamp to getdate() function

eg:getdate()
Ans :2008-07-24 13:02:48.727
i want to get 2008-07-24 24:59:59.727

---

quote:

---

Originally posted by Peso

SELECT	DATEADD(DAY, DATEDIFF(DAY, '19000101', getdate()), '19000101 23:59:59.997'),
	DATEADD(DAY, DATEDIFF(DAY, '19000101', getdate()), '19000102')

If you are going to compare the date with a column in a table like this

select * from table1 where column1 <= {above first result}

you are better off with using the second result like this

select * from table1 where column1 < {above second result}

That way, you are sure that all records for today are fetched, and your code will work on SQL Server 2008 as well.
Pre SQL Server 2008 has a time resolution of 3/1000th of a second. That's why 997 milliseconds are the last time for a day.

That is going to change in SQL Server 2008. There you can have a resolution of a microsecond Yes, then the time part will end with .999999

So use the second alternative above to compare dates.

---

E 12°55'05.25"
N 56°04'39.16"

---

quote:

---

Originally posted by aoriju

Not worry about millisecond ....i want last time of today in getdate function()

quote:

---

Originally posted by Peso

SELECT	DATEADD(DAY, DATEDIFF(DAY, '19000101', getdate()), '19000101 23:59:59.997'),
	DATEADD(DAY, DATEDIFF(DAY, '19000101', getdate()), '19000102')

If you are going to compare the date with a column in a table like this

select * from table1 where column1 <= {above first result}

you are better off with using the second result like this

select * from table1 where column1 < {above second result}

That way, you are sure that all records for today are fetched, and your code will work on SQL Server 2008 as well.
Pre SQL Server 2008 has a time resolution of 3/1000th of a second. That's why 997 milliseconds are the last time for a day.

That is going to change in SQL Server 2008. There you can have a resolution of a microsecond Yes, then the time part will end with .999999

So use the second alternative above to compare dates.

---

E 12°55'05.25"
N 56°04'39.16"

---

---

quote:

---

Originally posted by blindman

Jeez, people. Maybe he has a legit reason for wanting this:
select dateadd(millisecond, -2, dateadd(day, datediff(day, 0, getdate()), 0))

e4 d5 xd5 Nf6

---

select TodaysLastTime = dateadd(day,datediff(day,0,getdate()),'23:59:59.997')

Results:
TodaysLastTime                                         
------------------------------------------------------ 
2008-07-24 23:59:59.997

(1 row(s) affected)