Object

[system]

How Do i create an object by the name SYSDATE in the universe using the function ‘SYSDATE’?

---

Imonnira (BOB member since 2007-11-01)

[system]

Please try to post it in the Semantic Layer as this is of Universe Part.

And can’t we create object directly with SYSDATE name … ?

Thanks
Aniket

---

aniketp (BOB member since 2007-10-05)

[system]

You can create an object with the select portion that simply says SYSDATE. Because SYSDATE is not associated with a specific table, it will not parse on its own (just an oracle rule). It is still perfectly valid, and when used in a query with at least on object that DOES have an associated table, the query will work just fine.

---

Dwayne Hoffpauir (BOB member since 2002-09-19)

[system]

Also covered in the Designer FAQ here:

FAQ: Designer

How can I use the current system date in an object? You use a different function for each database. For example, Oracle users would typically use sysdate while Sybase or SQL Server users would use getdate(). Teradata uses DATE, and DB2 uses CURRENT_DATE. Ask your DBA if you are unsure which method is appropriate for you. Ok, so I have done that, but my object does not parse. How can I fix it? These functions or pseudo-columns do not need to reference a table. Yet when De…

Thanks

---

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