Skip to main content
edited tags
Link
user1822
user1822
Source Link

Firebird-Time Interval- between 2 Dates

I try to select the period of employment for the members in a Company.

Example: Date of join: 01.01.2001 Today: 27.02.2014 Now, I want this: 13 years, 1 month and 27 days

I have a Statement which works on MSSQL, but I cant translate it to firebird-SQL.

Could anybody help me?

Thx

Erik