Thank You for your reply.
BUT as i mentioned the date_time field is VARCHAR.
So if i use:
date >= '01/4/2000' and date < '01/5/2000'
this won't compare the dates it will compare Strings.
so '02/4/2000' will be GREATER than '01/5/2000'.
That is why i need a DATE TYPE for my field that can be used to create an
So any other ideas?
----- Original Message -----
From: Martijn van Oosterhout <kleptog(at)cupid(dot)suninternet(dot)com>
To: Andras Balogh <abalogh(at)grafx(dot)ro>
Sent: Wednesday, April 26, 2000 5:41 PM
Subject: Re: [GENERAL] pgsql DATE
> Andras Balogh wrote:
> > So i am looking a date type that would allow me to do the following with
> > (or a few) query
> > (and to be fast too):
> > -select all records for a given month
> > -select the count of records where the hour is 14.
> > -select all the records from the 7th week.
> > -select count of records where the day of the week is Sunday.
> > etc.
> How about you write your queries like:
> date >= '01/4/2000' and date < '01/5/2000'
> or equivalent. It allows use of the index but works the same.
> Except for the day is Sunday though...
> Martijn van Oosterhout <kleptog(at)cupid(dot)suninternet(dot)com>
In response to
pgsql-general by date
|Next:||From: Elmar.Haneke||Date: 2000-04-27 08:38:55|
|Subject: sequences and Transactions|
|Previous:||From: Peter Eisentraut||Date: 2000-04-27 08:02:32|
|Subject: Re: [HACKERS] pgsql/php3/apache authentication|