Removing time from DATETIME

[MarkP]

Both Oracle and SQL Server solutions are covered here:

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 …