How writen current date sql query in universe?

[system]

Hi,
How writen current date sql query in universe(idt)

---

sekhar4 (BOB member since 2015-07-06)

[MarkP]

Have a look through this topic:

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…

[system]

Hi,

It depends on the database that you use. So please provide this information. Or even better have a look at the topic that Mark P linked above.

---

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