How to retrieve system date

[Former Member]

Hello everybody.

I'm new in the Universe Designer world and I have one question to you all...

I have one object with a date and I want to see how many months as passed between that date and the current date (system date).

I know that there is a function for that, but my problem is how can I get the system date. I've tried to use the GETDATE() function but it gives me an error...

Anyone as an idea?

Thanks a lot,

Luis

[Former Member · Accepted solution]

http://www.dagira.com/2007/08/22/dynamic-dates-part-i-yesterday-and-today/

That blog post includes functions to get "today" for:

DB2 current date

Oracle sysdate

Informix TODAY

MySQL CURDATE()

SQL Server getdate()

Sybase getdate()

Teradata DATE or CURRENT_DATE

It is also the first in a series of posts that show you how to create other creative time objects for use in your universe. Hope this helps.

[Former Member]

Hi,

Oracle: Try with Sysdate()

SQL Server: GetDate()

Cheers,

Suresh Aluri.

[MariannevL]

Or

Currdate()

Really depends on the underlying RDMB, get your hands on a SQL syntax guide for yours (or google it

Oracle, SQLserver, etc. each have there own SQL dialect.

Hope this helps,

Marianne

[amrsalem1983]

try

sysdate