Current data in Universe as a object

[system]

Database Designer FAQ:

FAQ: Designer Database Specific

How do I get the current date as an object in my universe? Oracle - define your object as trunc(sysdate) SQL Server - define your object as cast(convert(char(10),getdate(),23) as datetime) This will remove the time section from your getdate() function - just use getdate() if you want current date and time. DB2 - define your object as one of the following CURRENT DATE CURRENT TIME CURRENT TIMESTAMP DATE(CURRENT TIMESTAMP) See this page for more detailed information …

---

Dave Rathbun (BOB member since 2002-06-06)