problem in select data from database

[Hamayun Khan]

hi

I want to execute the following query against sql2005

"SELECT tblregion.Regio n, tblJobPost.* FROM tblJobPost LEFT OUTER JOIN tblregion ON tblJobPost.regi on_id = tblregion.Regio nID Where
day(tblJobPost. postdate)=day(d ate()) and month(tblJobPos t.postdate)=mon th(date()) and year(tblJobPost .postdate)=year (date())"
this generate the following error

'date' is not a recognized built-in function name.

I m not an sql expert. I need query equivalent to the above

[debasisdas]

You need to use getdate() in place of date()

[kunal pawar]

In Sql server no data function is available, so there should be getdate() function for get current date

refer this link
http://msdn2.microsoft .com/en-us/library/ms186724.aspx