How do I get the current date as an object in my universe?
Oracle - define your object as
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
See this page for more detailed information
These objects will not parse in the universe because they do not have associated tables. Nor will they run if you build a query against just that object. As soon as other objects are included that do have a table associated with them, i.e. a standard column, then the query will work.
Mark P (BOB member since 2003-02-03)