How to get server date

[sergei]

Hi all,

I need to get the server date from my Delphi App running Merant ODBC 3.6 ProgressSQL 92 v9.1D. Something like SELECT CURRENT_DATE FROM ...

Any help would be appreciated.

Best regards,

Sergei Safar

 

[plus_marca]

Hi.

the function is CURDATE()

 

[sergei]

Hi,

thank you for your quickly reply. I saw this function on the manual, but how can I use CURDATE() ? Any example ?

I tried SELECT CURDATE() and got

Error: Syntax error (7587) (State:37000, Native Code: FFFFB1DD)


Best regards,

Sergei Safar

 

[plus_marca]

Hi.

Try something like this:

select curdate() from sysprogress.systabauth;

 

[sergei]

Hi,

thank you for your reply. I did a little modification:

select distinct curdate() from "pub"."_systabauth"

Thank you again.