Results 1 to 2 of 2

Thread: date calculations

  1. 02-16-2004, 02:06 AM #1
    narasimha
    narasimha is offline Registered User
    Join Date
    Feb 2004
    Posts
    2

    date calculations

    i want to get the records of people whose birth days are in the next 10 days.
    Reply With Quote Reply With Quote
  2. 02-18-2004, 04:48 PM #2
    ccalender
    ccalender is offline Registered User
    Join Date
    Jan 2004
    Location
    Cincinnati, OH
    Posts
    30
    select * from YourTable
    where
    (unix_timestamp(date_format($dob,"2004-%m-%d 00:00:00")))
    between (unix_timestamp(date_format(curdate(),"2004-%m-%d 00:00:00")))
    and (unix_timestamp(date_format((curdate()+interval 10 day),"2004-%m-%d 00:00:00")))

    $dob is the date of birth.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules