Postgres Pro
Downloads
Home   >   mailing lists

Birth Day Calculation - Mailing list pgsql-sql

From Ashish Karalkar
Subject Birth Day Calculation
Date
Msg-id 01d801c7c92b$317e83a0$170211ac@LIONKING.COM
Whole thread Raw
Responses Re: Birth Day Calculation
List pgsql-sql
Tree view
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...

pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Database Synchronization
Next
From: "Fernando Hevia"
Date:
Subject: Re: Inserting an IF statement in the middle of a SELECT in pl/pgSQL code