Skip to Content
avatar image
Former Member

How to retrieve system date

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 10, 2010 at 11:32 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 02, 2010 at 10:31 AM

    try

    sysdate

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 03, 2010 at 09:53 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 07, 2010 at 10:25 AM

    Hi,

    Oracle: Try with Sysdate()

    SQL Server: GetDate()

    Cheers,

    Suresh Aluri.

    Add comment
    10|10000 characters needed characters exceeded