Results 1 to 3 of 3

Thread: Select data for particular time period

  1. 05-04-2008 #1
    Vasanth.sql
    Vasanth.sql is offline
    Junior Member
    Join Date
    May 2008
    Answers
    3

    Select data for particular time period

    Can I retrieve the data between 2 specified dates and falling between 4th hour of Monday and 10th hour of Thursday everyweek.

    Note: The 2 dates, the starting weekday,hour and ending weekday, hour can change depending on the input.

    Thanks before hand for the help.

    Reply With Quote Reply With Quote
  2. 05-05-2008 #2
    krishnaindia2007
    krishnaindia2007 is offline
    Expert Member
    Join Date
    Sep 2007
    Answers
    697

    Re: Select data for particular time period

    Yes you can.

    Reply With Quote Reply With Quote
  3. 05-05-2008 #3
    debasisdas
    debasisdas is offline
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074
    Send a message via ICQ to debasisdas Send a message via AIM to debasisdas Select data for particular time period

    Re: Select data for particular time period

    You simply need to pass the condition in the where clause of your SQL query.

    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

About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
GeekInterview
Interact