| Subject | Re: select birthdays form the next several days |
|---|---|
| Author | Ian A. Newby |
| Post date | 2005-09-23T12:31:49Z |
How about
select birthday from persons
where mod((current_date - birthday) / 365.25) < (14 / 365)
you'll need a MOD udf though.
It may be a bit inaccurate, but should be nearly there.
regards
Ian Newby
select birthday from persons
where mod((current_date - birthday) / 365.25) < (14 / 365)
you'll need a MOD udf though.
It may be a bit inaccurate, but should be nearly there.
regards
Ian Newby