T. BlomInformation analyst tbl@shimano-eu.com RE: current date in interbase MartijnTonies (Programmer)4 Nov 03 11:41In IB6, dialect 3, you can use:CURRENT_DATECURRENT_TIMECURRENT_TIMESTAMP (date & time)For IB 'NOW' Martijn ToniesDatabase Workbench - the developer tool for InterBase, Firebird and MS SQL Server RE: current date in interbase blom0344 (TechnicalUser)(OP)4 Nov 03 14:53Thanks Martijn,Upon getting access to the database I found 6 UDF's available, among them :F_MONTH F_YEARThese are supposed to work on dates, but bothF_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. BlomInformation analyst tbl@shimano-eu.com RE: current date in interbase MartijnTonies (Programmer)5 Nov 03 02:10You 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 ToniesDatabase Workbench - the developer tool for InterBase, Firebird and MS SQL Server RE: current date in interbase blom0344 (TechnicalUser)(OP)5 Nov 03 08:47Martijn, Thanks again , got it working with dialect 3 on Interbase version 6.5.0.28Is CASE supported within Interbase like:Select CASE WHEN ...... THEN .... ELSE .... END or an alternative?Thanks so much for your answers, very helpful.. T. BlomInformation analyst tbl@shimano-eu.com RE: current date in interbase MartijnTonies (Programmer)5 Nov 03 08:52Hi,InterBase does not support CASE or equivalents functions. Martijn ToniesDatabase Workbench - the developer tool for InterBase, Firebird and MS SQL Server googletag.cmd.push(function() googletag.display('div-gpt-ad-1406030581151-2'); ); Red Flag This PostPlease let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.CancelRed Flag SubmittedThank you for helping keep Tek-Tips Forums free from inappropriate posts.The Tek-Tips staff will check this out and take appropriate action.
Interbase 6.5
2ff7e9595c
Comments