SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Thread: How to return events with two dates if current_date.

  1. Oct 28, 2009 07:08 #1
    dele454
    dele454 is offline
    Strokin' Morango dele454's Avatar
    Join Date
    Oct 2005
    Location
    Cape town, South Africa
    Posts
    294
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How to return events with two dates if current_date.

    Hi,

    I need to find a way of detecting events as detailed below. Thanks in advance

  2. Oct 28, 2009 07:31 #2
    r937
    r937 is online now
    SQL Consultant silver trophybronze trophy
     SitePoint Award Recipient r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    38,513
    Mentioned
    35 Post(s)
    Tagged
    1 Thread(s)
    Code:
    WHERE CURRENT_DATE BETWEEN fromdate AND todate
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"
  3. Oct 28, 2009 08:14 #3
    dele454
    dele454 is offline
    Strokin' Morango dele454's Avatar
    Join Date
    Oct 2005
    Location
    Cape town, South Africa
    Posts
    294
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks Rudy I figured it out after i made the post. Now i feel dumb!
« Previous Thread | Next Thread »

Bookmarks

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