Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
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