sysdate with SQL server05

[system]

HI everybody!

I’m trying to add a filter in my Univers which could filter my data for the actual year. When I worked with Oracle I wrote:

to_number(to_char(sysdate,‘yyyy’)) = @Select(Time\Year)

Anyone know how can I do the same with SQL server?

Thank you very much!!!

---

eloibague (BOB member since 2010-11-24)

[system]

Hi,

This sticky topic will help you:

DB-specific Relative Dates SQL Server, Oracle, Netezza, DB2

As per this topic on Oracle relative dates, here’s the same set of dates in SQL Server. Please note that some may not work on SQL Server 2000, but all definitely work in 2005/8. Yesterday cast(convert(char(10),dateadd(d,-1,getdate()),23) as datetime) Today cast(convert(char(10),getdate(),23) as datetime) The following also works for today: dateadd(dd, datediff(dd,0,getdate()), 0) Start of Current Month cast(convert(char(7),getdate(),23)+'-01' as datetime) End of Current Month dateadd(d,-1…

---

Marek Chladny (BOB member since 2003-11-27)

[system]

Thank you very much.
I couldn’t find it!

---

eloibague (BOB member since 2010-11-24)