Post reply

SELECT Help

  • December 22, 2005 at 7:51 am

    #611131

    Does this help?

    select birth_date

    from date_test

    order by datepart(month, birth_date),

    datepart(day,birth_date)

  • December 22, 2005 at 10:12 am

    #611181

    Or try this on:

    select convert(varchar,birthDate ,101)

    From delete_temptest

    order by datepart(month, dateadd(m,-6,birthDate)),

    datepart(day,birthdate)

  • December 22, 2005 at 10:18 am

    #611183

    David Burrows,Sam Rabie,

    Both solutions worked, thanks a lot.

     

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply