Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Select system date in isql/Allbase

Neeraja
Occasional Visitor

Select system date in isql/Allbase

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
6 REPLIES
Peter Godron
Honored Contributor

Re: Select system date in isql/Allbase

Hi,
current_date,current_time, current_timestamp
should work?
Neeraja
Occasional Visitor

Re: Select system date in isql/Allbase

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
Honored Contributor

Re: Select system date in isql/Allbase

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
Honored Contributor

Re: Select system date in isql/Allbase

SELECT CURRENT_DATE FROM RDB$DATABASE
Neeraja
Occasional Visitor

Re: Select system date in isql/Allbase

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
Occasional Visitor

Re: Select system date in isql/Allbase

Hello Spex,

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

Neeraja