From: Del Mistro, Enzo <enzo.delmistro@eds.com>
To: 'pgsql-sql@postgreSQL.org' <pgsql-sql@postgreSQL.org>
Subject: Year and month comparison
Date: Tue, 10 Sep 2002 16:16:04 -0400
Message-ID: <60D032C6B8E4D211B8A300805FEADEAA0D91F992@CAMKM201> (raw)
Hi all,
I am trying to perform a Year and Month comparison from a date field.
Within oracle this is working, however within the Postgresql environment I
am getting an error.
I currently have a call as follows:
select descr
and (to_char(subsc_paid_to_dt,'YYYYMM') < to_char(current_date,'YYYYMM')
(so this is performing a comparison by year and month, not by actual day of
the month)
Any suggestions?
Thanks & regards,
Enzo
Enzo Del Mistro *
33 Yonge St, Suite 500, * Toronto, ON
Phone: 001 416 814 1741
E-Mail: enzo.delmistro@eds.com
> Business Acceleration Services TOR,
> Solutions Consulting
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: enzo.delmistro@eds.com
Subject: Re: Year and month comparison
In-Reply-To: <60D032C6B8E4D211B8A300805FEADEAA0D91F992@CAMKM201>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox