From ashish.karalkar@info-spectrum.com Wed Jul  18 11:03:19 2007
Received: from localhost (maia-5.hub.org [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id CDF449FB371
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed, 18 Jul 2007 08:03:19 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024)
	with ESMTP id 25709-05 for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed, 18 Jul 2007 08:03:07 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from pro33.abac.com (pro33.abac.com [66.226.64.34])
	by postgresql.org (Postfix) with ESMTP id 8B02F9FB310
	for <pgsql-sql@postgresql.org>; Wed, 18 Jul 2007 08:03:11 -0300 (ADT)
Received: from ashishk (61.17.93.7.static.nagpur.vsnl.net.in [61.17.93.7] (may
	be forged)) (authenticated bits=0)
	by pro33.abac.com (8.13.8/8.13.8) with ESMTP id l6IB33sj042359
	(version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NO)
	for <pgsql-sql@postgresql.org>; Wed, 18 Jul 2007 04:03:07 -0700 (PDT)
	(envelope-from ashish.karalkar@info-spectrum.com)
Message-ID: <01d801c7c92b$317e83a0$170211ac@LIONKING.COM>
From: "Ashish Karalkar" <ashish.karalkar@info-spectrum.com>
To: <pgsql-sql@postgresql.org>
Subject: Birth Day Calculation
Date: Wed, 18 Jul 2007 16:32:50 +0530
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_01D5_01C7C959.48107960"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200707/112
X-Sequence-Number: 28847

This is a multi-part message in MIME format.

------=_NextPart_000_01D5_01C7C959.48107960
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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=20

Thanks in advance
Ashish...
------=_NextPart_000_01D5_01C7C959.48107960
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.5730.11" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hello All,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>I want to diplay all the name of =
persons who falls=20
in between given day and month</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>something like</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>select name from my_table mt =
where&nbsp;=20
mt.date_of_birth between 7-Jul and 15 - Aug</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>column date_of_birth is of date =
type</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>is there any way to do this =
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks in advance</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Ashish...</FONT></DIV></BODY></HTML>

------=_NextPart_000_01D5_01C7C959.48107960--




From osvaldo_kussama@yahoo.com.br Wed Jul  18 13:53:48 2007
Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id 690FE9FBB44
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed, 18 Jul 2007 10:53:48 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024)
	with ESMTP id 05416-02 for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed, 18 Jul 2007 10:53:37 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from smtp109.mail.mud.yahoo.com (smtp109.mail.mud.yahoo.com
	[209.191.85.219])
	by postgresql.org (Postfix) with SMTP id 889449FBB5C
	for <pgsql-sql@postgresql.org>; Wed, 18 Jul 2007 10:53:42 -0300 (ADT)
Received: (qmail 7170 invoked from network); 18 Jul 2007 13:53:41 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.br;
	h=Received:X-YMail-OSG:Message-ID:Date:From:User-Agent:MIME-Version:To:CC:Subject:References:In-Reply-To:Content-Type:Content-Transfer-Encoding;
	b=eGQO4vzp759a8PYhqlyEzk39JLYUcs6XoLKt8lcZxoRwG/WbSahzSnDx89T+2rmged5MaodrFWUiovbfaNcYdB5W8yvaoK1wWHnKyIOA2kB9q6/guqAq2AHavR8epzWNJJdn4uKor2ahYf7ly7MxhRp04h/7z48+UYh69MKNGQA=
	;
Received: from unknown (HELO ?10.2.200.151?) (osvaldo_kussama@189.25.6.151
	with plain)
	by smtp109.mail.mud.yahoo.com with SMTP; 18 Jul 2007 13:53:40 -0000
X-YMail-OSG: pw9kHS4VM1k.hIiZVKFrsjt4RfKaolBIBPLCDrCcmLCarIhF
Message-ID: <469E1BF4.1020605@yahoo.com.br>
Date: Wed, 18 Jul 2007 10:56:04 -0300
From: Osvaldo Rosario Kussama <osvaldo_kussama@yahoo.com.br>
User-Agent: Thunderbird 1.5.0.12 (X11/20070530)
MIME-Version: 1.0
To: Ashish Karalkar <ashish.karalkar@info-spectrum.com>
CC: pgsql-sql@postgresql.org
Subject: Re: Birth Day Calculation
References: <01d801c7c92b$317e83a0$170211ac@LIONKING.COM>
In-Reply-To: <01d801c7c92b$317e83a0$170211ac@LIONKING.COM>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001
X-Spam-Level: 
X-Archive-Number: 200707/114
X-Sequence-Number: 28849

Ashish Karalkar escreveu:
> 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
>  


SELECT name FROM my_table mt
  WHERE to_char(mt.date_of_birth,'mmdd') between '0707' and '0815'

Osvaldo