Received: from mail.ldssingles.com (mail.ldssingles.org [63.226.117.101]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4VHEdE57259 for ; Thu, 31 May 2001 13:14:39 -0400 (EDT) (envelope-from mark@zserve.com) Received: from mark.ldssingles.com (mark.ldssingles.com [192.168.1.31]) by mail.ldssingles.com (8.11.2/8.11.2) with ESMTP id f4VHEbW24511 for ; Thu, 31 May 2001 11:14:37 -0600 Message-Id: <200105311714.f4VHEbW24511@mail.ldssingles.com> Subject: Date manipulation From: Mark To: pgsql-sql@postgresql.org Content-Type: text/plain X-Mailer: Evolution (0.9 - Preview Release) Date: 31 May 2001 10:22:48 -0600 Mime-Version: 1.0 X-Archive-Number: 200105/360 X-Sequence-Number: 3201 How does one perform date manipulation within SQL? For example, SQL Server has a dateadd() function that takes a date part, scalar, and the date to manipulate. I have a query that determines the number of days that are between now and a particular date that looks something like this: select datediff (dd, now (), column) as difference_in_days from ... Anything available short of coding my own function? Thanks, Mark