Birth Day Calculation

From: "Ashish Karalkar" <ashish(dot)karalkar(at)info-spectrum(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Birth Day Calculation
Date: 2007-07-18 11:02:50
Message-ID: 01d801c7c92b$317e83a0$170211ac@LIONKING.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello All,

I want to diplay all the name of persons who falls in between given day and month
something like

select name from my_table mt where mt.date_of_birth between 7-Jul and 15 - Aug

column date_of_birth is of date type

is there any way to do this

Thanks in advance
Ashish...

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Fernando Hevia 2007-07-18 12:46:33 Re: Inserting an IF statement in the middle of a SELECT in pl/pgSQL code
Previous Message Richard Huxton 2007-07-18 07:28:36 Re: Database Synchronization