[thelist] SQL query help: dates

[Anthony Baratta]

At 11:25 AM 2/17/2005, Madhu Menon wrote:

>Won't work. One thing to remember is that birthdays also record the year 
>of birth. I'm 30 Nov, 1975, so my birth date would not fall in the range 
>you've specified (between now and 10 days from now.) ;)

Doh! I wasn't paying close enough attention. Here is some SQL code that 
forgot I wrote to get birthdays out of a DB.

SELECT
     FirstName
     ,LastName
     ,CAST(Month(Birthdate) as varchar) + '/' + CAST(Day(Birthdate) as 
varchar) as Birthdate
     ,IMDBLink
     ,MiscInfo
FROM StarWarsBirthdays
WHERE CAST(CAST(Month(Birthdate) as varchar) + '/' + CAST(Day(Birthdate) as 
varchar) + '/' + CAST(Year(GetDate()) as varchar) + ' 00:00:00' as datetime)
     BETWEEN
     CAST(CAST(Month(GetDate()) as varchar) + '/' + CAST(Day(GetDate()) as 
varchar) + '/' + CAST(Year(GetDate()) as varchar) + ' 00:00:00' as datetime)
     AND
     CAST(CAST(Month(DateAdd(dd," & iDay & ",GetDate())) as varchar) + '/' 
+ CAST(Day(DateAdd(dd," & iDay & ",GetDate())) as varchar) + '/' + 
CAST(Year(DateAdd(dd," & iDay & ",GetDate())) as varchar) + ' 23:59:59' as 
datetime)
ORDER BY CAST(CAST(Month(Birthdate) as varchar) + '/' + CAST(Day(Birthdate) 
as varchar) + '/' + CAST(Year(GetDate()) as varchar) + ' 00:00:00' as datetime)