current date in interbase 1

[blom0344]

What is the equivalent of current_date or sysdate in interbase?

Does anyone have a good reference on what is possible SQL wise with Interbase SQL.

Seems a lot of functions are not available standardwise...

T. Blom
Information analyst
tbl@shimano-eu.com

 

[MartijnTonies]

In IB6, dialect 3, you can use:

CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP (date & time)

For IB < 6, or dialect 1, you can use:
'NOW'



Martijn Tonies
Database Workbench - the developer tool for InterBase, Firebird and MS SQL Server

http://www.upscene.com

 

[blom0344]

Thanks Martijn,

Upon getting access to the database I found 6 UDF's available, among them :

F_MONTH
F_YEAR

These are supposed to work on dates, but both
F_YEAR(CURRENT_DATE) and F_YEAR(NOW) are giving me SQL errors.

Anyway I think that our dialect is 1, but can I check that somehow?

T. Blom
Information analyst
tbl@shimano-eu.com

 

[MartijnTonies]

You can check the dialect via the database properties in IBConsole (or another (3rd party) tool).

What SQL errors? Do note, that UDFs need to be declared first.


Martijn Tonies
Database Workbench - the developer tool for InterBase, Firebird and MS SQL Server

http://www.upscene.com

 

[blom0344]

Martijn,

Thanks again , got it working with dialect 3 on Interbase version 6.5.0.28

Is CASE supported within Interbase like:

Select CASE WHEN ...... THEN .... ELSE .... END

or an alternative?

Thanks so much for your answers, very helpful..

T. Blom
Information analyst
tbl@shimano-eu.com

 

[MartijnTonies]

Hi,

InterBase does not support CASE or equivalents functions.


Martijn Tonies
Database Workbench - the developer tool for InterBase, Firebird and MS SQL Server

http://www.upscene.com