Year and month comparison

From: "Del Mistro, Enzo" <enzo(dot)delmistro(at)eds(dot)com>
To: "'pgsql-sql(at)postgreSQL(dot)org'" <pgsql-sql(at)postgreSQL(dot)org>
Subject: Year and month comparison
Date: 2002-09-10 20:16:04
Message-ID: 60D032C6B8E4D211B8A300805FEADEAA0D91F992@CAMKM201
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(dot)delmistro(at)eds(dot)com
> Business Acceleration Services TOR,
> Solutions Consulting
>
>

Browse pgsql-sql by date

  From Date Subject
Next Message Mark Worsdall 2002-09-10 21:50:42 Do the datatypes have set id/oid that are constant?
Previous Message Kevin Brannen 2002-09-10 19:51:54 Re: Changing Column Type