Select system date in isql/Allbase

[Neeraja]

Hello All,

Can you please suggest me how to extract the system date in iSQL/ALLBASE?

Like in Oracle, we extract the system date with the following query

select sysdate from dual;

How do we acheive the same in iSQL/ALLBASE.

Thanks in advance for your reply

Regards,
Neeraja

[Peter Godron]

Hi,
current_date,current_time, current_timestamp
should work?

[Neeraja]

Thanks Peter for the response.

Can you please be kind enough to let me know the complete query?

I could find from the net about current_date,current_time etc but not able to write query.

Thanks again

Neeraja

[spex]

Hi Neeraja,

Here's the "ALLBASE/SQL to Oracle Migration Guide":
http://www.oracle.com/technology/software/tech/migration/toolkits/allbase/allbase.pdf

The answer to your question is on page 136.

PCS

[spex]

SELECT CURRENT_DATE FROM RDB$DATABASE

[Neeraja]

Hello Spex,

I get the following error when i execute the query you had mentioned

Table/View DBA.RDB$DATABASE not found. (DBERR 2206)

Thanks,
Neeraja

[Neeraja]

Hello Spex,

DBA.RDB$DATABASE -> Hope you meant that i need to give the database name in place of "DATABASE". am i right?

Neeraja