Postgres Pro
Downloads
Home   >   mailing lists

Re: Select data for current week only - Mailing list pgsql-general

From Sam Mason
Subject Re: Select data for current week only
Date
Msg-id 20090827191051.GB5407@samason.me.uk
Whole thread Raw
In response to Select data for current week only  (BlackMage <dsd7872@uncw.edu>)
List pgsql-general
Tree view 
On Thu, Aug 27, 2009 at 11:09:36AM -0700, BlackMage wrote:
> The field I am using for sorting is a Date type with the format yyyy-mm-dd
> hh:mm:ss .

Values that look like that are normally stored in timestamp columns, not
date column.  You wouldn't get the time part if it was just a date.

--
  Sam  http://samason.me.uk/

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: Select data for current week only
Next
From: Thomas Kellerer
Date:
Subject: Re: Select data for current week only