Received: from symcom.com ([209.11.41.82]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7MJWrP11421 for ; Wed, 22 Aug 2001 15:32:55 -0400 (EDT) (envelope-from pgsql@symcom.com) Message-Id: <200108221932.f7MJWrP11421@postgresql.org> Received: from WorldClient [209.11.41.82] by symcom.com [209.11.41.82] with SMTP (MDaemon.v3.5.0.R) for ; Wed, 22 Aug 2001 15:37:35 -0400 Date: Wed, 22 Aug 2001 15:37:35 -0400 From: "postgresql" To: "PgSQL-SQL" Subject: just checking X-Mailer: WorldClient Pro 2.2.1 X-MDRemoteIP: 209.11.41.82 X-Return-Path: pgsql@symcom.com X-MDaemon-Deliver-To: pgsql-sql@postgresql.org X-Archive-Number: 200108/288 X-Sequence-Number: 4534 At times things seem just too easy, so I want to confirm that this is the correct syntax. I am looking for the interval (aging) for these invoices. I guess I am concerned because I guessed at the syntax. Is there a better way to do this? billdate is type 'date' SELECT ('now'-billdate) FROM fcinvoiced WHERE client = 'smith'; Ted