help with GETDATE() - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

help with GETDATE()

Author

Topic

erica686
Starting Member

13 Posts

Posted - 2010-01-14 : 18:43:04

I have the following query:

select amount
where tran_date >= getdate()

the problem that i have is that the transaction date is: 15/01/2010 12:00:00 AM, but the getdate formula will give me 15/01/2010 9:36:AM. So all transactions for the 15th will be excluded.. is there anyway around this?

Thanks,
E

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2010-01-14 : 18:49:28

SELECT Amount
FROM Table1
WHERE TranDate >= DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()), 0)

N 56°04'39.26"
E 12°55'05.63"