BusinessObjects Board

Date Issue

building semantic layer

system June 3, 2013, 1:10pm 2

Hi,

This sticky topic will help you:

DB-specific Relative Dates SQL Server, Oracle, Netezza, DB2 building semantic layer

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)

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled