Grabbing month/day out of a date field.
Posted: Fri Jan 30, 2004 2:08 pm
I'm attempting to get everyone who has a birthday.
My code runs a SQL statement where it tries to grab the month and day from the age field.
when i do
WHERE age = '2000-01-30"'
It returns results
How do I return all results WHERE age = '01-30'
I tried stristr(age,'01-30')
and substr(age,5,5)
But both of those return nothing. So whats the correct way to do this?
My code runs a SQL statement where it tries to grab the month and day from the age field.
when i do
WHERE age = '2000-01-30"'
It returns results
How do I return all results WHERE age = '01-30'
I tried stristr(age,'01-30')
and substr(age,5,5)
But both of those return nothing. So whats the correct way to do this?