| From: | Lincoln Yeoh <lylyeoh(at)mecomb(dot)com> |
|---|---|
| To: | "Andras Balogh" <abalogh(at)grafx(dot)ro>, "Martijn van Oosterhout" <kleptog(at)cupid(dot)suninternet(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pgsql DATE |
| Date: | 2000-04-27 09:28:35 |
| Message-ID: | 3.0.5.32.20000427172835.0091cce0@pop.mecomb.po.my |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
At 11:03 AM 27-04-2000 +0300, Andras Balogh wrote:
>Hi,
>
>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
>index.
>
>So any other ideas?
If you need a date type for your field, use a date type.
http://www.postgresql.org/docs/postgres/datatype1143.htm
Cheerio,
Link.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Malcolm Beattie | 2000-04-27 09:51:32 | Re: [HACKERS] pgsql/php3/apache authentication |
| Previous Message | Jan Wieck | 2000-04-27 09:17:39 | Re: [HACKERS] pgsql/php3/apache authentication |