Return integer value of age(date) function in Postgres

Question

I would like to determine the number of days that an account has been open. Ideally, I would like to compare the return value to an integer(days). i.e

I would like to see if age(open_date) > 14

If anyone has any better ideas...

Thanks

Vao Tsun · Accepted Answer · 2015-06-23 08:15:16Z

1

Here is how you get the number of days comparing two dates:

SQL> select extract(day from now()-'2015-02-21'::timestamptz); date_part ----------- 122 (1 row)

answered Jun 23, 2015 at 8:15

Vao Tsun

52.4k13 gold badges114 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

jaredlee.exe Over a year ago

This worked really well :) "extract(day from current_date-open_date::timestamptz)= 14" I wanted to ask what the 'tz' at the end of timestamp meant?

Vao Tsun Over a year ago

timestamp with TIME ZONE

Collectives™ on Stack Overflow

Return integer value of age(date) function in Postgres

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related