How to use DATEDIFF in metabase v0.38.4?

Get Help
1

i'm trying to find date difference

SELECT DATEDIFF('year',now(), now()) AS DateDiff;

but it's giving me error message

ERROR: function datediff(timestamp with time zone, timestamp with time zone) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 128

i have also take look at below Topic but it's not helping. please, help!!.

Date diffrent sql query
Use datediff in metabase

2

Hi @sidpro

  1. You should upgrade immediately to a newer release:
    https://github.com/metabase/metabase/releases
  2. Try using a function that is supported by your database type. Then it will work. It's difficult to tell which database type you're using, but I'm guessing it's Postgres:
    https://stackoverflow.com/questions/24929735/how-to-calculate-date-difference-in-postgresql
3

it's postgres

4

i tried using date1 - date2 which gives output as 0 years 0 mons 1 days 20 hours 20 mins 6.91 secs. If I want to check whether the difference is 1 day, i simply compare against string value "1 days"