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

General SQL Server Forums

New to SQL Server Programming

getdate()

Author

Topic

lemondash
Posting Yak Master

159 Posts

Posted - 2007-05-21 : 07:30:30

select
H.IsoDate,
HI.Country,
HI.Center,
H.ExchangeCode,
HC.Holiday,
H.HolidayCode
from
Holidays H
join
HolidayInfo HI
on
HI.Code = H.ExchangeCode
join
HolidayCodes HC
on
H.HolidayCode = HC.Code
where
H.isodate = getdate()

This is a script but the getdate part is not working can somebody point me in the right direction where i might be going wrong.

The date format in H.isodate is like this:

2005-06-24 00:00:00.000

cheers in advance

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-05-21 : 07:30:55

duplicate thread http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=83879

lemondash
Posting Yak Master

159 Posts

Posted - 2007-05-21 : 07:35:31

Cheers you are a super star !!!!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources