Previous date data

[system]

@sandeepmunagala

What do you mean by stickies? I tried to search it but not many ans…

Top post in this forum. Gives you all the date codes/formulae for SQL server & Oracle

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…

A search gave me these:

120×120 10.4 KB

HI , I need to create an object which just uses sysdate in designer for a report. I want the objects to be there at designer Appreciate your assistance sethybibeka (BOB member since 2005-12-23)

120×120 10.4 KB

Hi Gurus, I need to create an object like this ( sysdate -2years) i.e I should get the result like this. If the sysdate is 10/19/2010 the result set should be 10/19/2008. Any help is appreciated. Thanks, Sukumar reddy1868 (BOB member since 2010-01-28)

And there’s Dave’s blog which is incredibly useful:

http://www.dagira.com/category/design/dynamic-dates/

Debbie

---

Debbie (BOB member since 2005-03-01)