current date in interbase 1

• Nov 4, 2003

1
• #2

MartijnTonies

Programmer

Jun 5, 2002

212

NL

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

 

Upvote 0 Downvote

• Nov 4, 2003

• Thread starter
• #3

blom0344

Technical User

Mar 20, 2002

3,441

NL

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

 

Upvote 0 Downvote

• Nov 4, 2003

• #4

MartijnTonies

Programmer

Jun 5, 2002

212

NL

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

 

Upvote 0 Downvote

• Nov 5, 2003

• Thread starter
• #5

blom0344

Technical User

Mar 20, 2002

3,441

NL

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

 

Upvote 0 Downvote

• Nov 5, 2003

• #6

MartijnTonies

Programmer

Jun 5, 2002

212

NL

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

 

Upvote 0 Downvote