Skip to Content
avatar image
Former Member

Retrieve date/time (timestamp) from MaxDB?

Hi,

how to retrieve date and time from MaxDB?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 01, 2008 at 09:26 AM

    Hello,

    please try

    select now(), date(now()), time(now()) from dual

    Regards Thomas

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 01, 2008 at 12:41 PM

    Hi,

    and even the short

    select date, time, timestamp from dual

    will do

    Elke

    Add comment
    10|10000 characters needed characters exceeded