pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Birth Day Calculation
2+ messages / 2 participants
[nested] [flat]

* Birth Day Calculation
@ 2007-07-18 11:02 Ashish Karalkar <ashish.karalkar@info-spectrum.com>
  2007-07-18 13:56 ` Re: Birth Day Calculation Osvaldo Rosario Kussama <osvaldo_kussama@yahoo.com.br>
  0 siblings, 1 reply; 2+ messages in thread

From: Ashish Karalkar @ 2007-07-18 11:02 UTC (permalink / raw)
  To: 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...

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Birth Day Calculation
  2007-07-18 11:02 Birth Day Calculation Ashish Karalkar <ashish.karalkar@info-spectrum.com>
@ 2007-07-18 13:56 ` Osvaldo Rosario Kussama <osvaldo_kussama@yahoo.com.br>
  0 siblings, 0 replies; 2+ messages in thread

From: Osvaldo Rosario Kussama @ 2007-07-18 13:56 UTC (permalink / raw)
  To: Ashish Karalkar <ashish.karalkar@info-spectrum.com>; +Cc: pgsql-sql

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2007-07-18 13:56 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-07-18 11:02 Birth Day Calculation Ashish Karalkar <ashish.karalkar@info-spectrum.com>
2007-07-18 13:56 ` Osvaldo Rosario Kussama <osvaldo_kussama@yahoo.com.br>

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