cancel
Showing results for 
Search instead for 
Did you mean: 

Retrieve date/time (timestamp) from MaxDB?

Former Member
0 Kudos

Hi,

how to retrieve date and time from MaxDB?

Accepted Solutions (1)

Accepted Solutions (1)

TTK
Employee
Employee
0 Kudos

Hello,

please try

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

Regards Thomas

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

and even the short

select date, time, timestamp from dual

will do

Elke