Date Data Type

From: "Jillian Carroll" <jillian(at)koskie(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Date Data Type
Date: 2002-07-08 03:33:00
Message-ID: DCEBJACNIMLDFIOHMAJCAEEBCIAA.jillian@koskie.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I have a database upon which I am trying to do the following query:

select newsitem, category, link, datebox
from news_tbl
order by entered desc

It is very straightforward. Newsitem, Category and Link are all text data
types and datebox is date data type.

The query only works when datebox is not included.

I am running Postgres 7.2 on Redhad 7.2.

Is there a problem with the date data type?

--
Jillian

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-07-08 03:48:10 Re: database backup
Previous Message Curt Sampson 2002-07-08 03:10:28 Re: database backup