Question & Additional Information
 
How can we know the number of days between two given dates using MySQL?
Add to My IQ
 

Answer Title
Answer
Select datediff('2008-09-07','2006-10-02');
Question Tag Title
Tags
Question Asked At Title
Asked At
None
Question Job Title
Job Titles


Check out our newest job listings!

Post a Job! $49 for 60 days



Your Name:
Add your comment text
 
Related Questions
Related Questions
Flag this interview question as inappropriate Inappropriate
See Answer
  • To run the count program, which will display the process identification number of the job, enter: count &
  • To check the status of your job, enter: ps
  • To bring a background process to the foreground, enter: fg
  • If you have more than one job suspended in the background, enter: fg %#

    Replace  #  with the job number, as shown in the first column of the output of the jobs command.

  • You can kill a background process by entering: kill PID

    Replace PID with the process ID of the job. If that fails, enter the following:

    kill -KILL PID
  • To determine a job's PID, enter: jobs -l
  • If you are using sh, ksh, bash, or zsh, you may prevent background processes from sending error messages to the terminal. Redirect the output to /dev/null using the following syntax: count 2> /dev/null &
  • Create Date
    :
    Sunday, May 11, 2008
    Tags
    :
    Asked At
    :
    None
    Job Positions
    :
    Click here to improve the Interview Question, Answer and other fields.
    Comments (0) :
    Goto add your comment on the Question 
    Flag this interview question as inappropriate Inappropriate
    See Answer
    Binary Exponential Backoff Algorithm was chosen to dynamically adapt to the number of stations trying to send. If the randomization interval for all collision was 1023 slots, the chance of two stations colliding for a second time  would be negligible, but the average wait after a collision would be hundreds of slot times, introducing significant delay. On the other hand, if each station always delayed for either 0 or 1 slot, then if 100 stations ever tried to send at once, they would collide over and over until 99 of them picked 1 and the remaining station picked 0. This may take years. But having the randomization interval grow exponentially as more and more consecutive collisions occur, the algorithm ensures a low delay when only a few stations collide but also ensures that the collision is resolved in a reasonable interval when many stations collide. Truncating the backoff at 1023 keeps the bound from growing too large.
    Create Date
    :
    Monday, January 07, 2008
    Tags
    :
    None
    Asked At
    :
    None
    Job Positions
    :
    None
    Click here to improve the Interview Question, Answer and other fields.
    Comments (1) :
    1.
    hackone
    Tuesday, October 28, 2008 11:54 AM
    Binary Exponential Backoff Algorithm was chosen to dynamically adapt to the number of stations trying to send. If the randomization interval for all collision was 1023 slots, the chance of two stations colliding for a second time  would be negligible, but the average wait after a collision would be hundreds of slot times, introducing significant delay. On the other hand, if each station always delayed for either 0 or 1 slot, then if 100 stations ever tried to send at once, they would collide over and over until 99 of them picked 1 and the remaining station picked 0. This may take years. But having the randomization interval grow exponentially as more and more consecutive collisions occur, the algorithm ensures a low delay when only a few stations collide but also ensures that the collision is resolved in a reasonable interval when many stations collide. Truncating the backoff at 1023 keeps the bound from growing too large.
    Flag this interview question as inappropriate Inappropriate
    See Answer
    On AIX use  --
    groups -To Display full list
    id -G - To display group id number

    On Solaris use --
    groups - To display full list
    id -a - To diaplsy full list of groups with group id numbers

    Create Date
    :
    Wednesday, March 19, 2008
    Tags
    :
    Asked At
    :
    None
    Job Positions
    :
    Click here to improve the Interview Question, Answer and other fields.
    Comments (0) :
    Goto add your comment on the Question 
    Flag this interview question as inappropriate Inappropriate
    See Answer
    30
    Consider the number at the odd position, ignor the number at the even position. We have :
    2  =1*2
    6  =2*3
    12=3*4
    20=4*5
    so the next number must be :
    5*6=30.

    Create Date
    :
    Friday, May 09, 2008
    Tags
    :
    Asked At
    :
    Job Positions
    :
    Click here to improve the Interview Question, Answer and other fields.
    Comments (0) :
    Goto add your comment on the Question 
    Flag this interview question as inappropriate Inappropriate
    See Answer
    Start with the present and tell why you are well qualified for the position. Remember that the key to all successful interviewing is to match your qualifications to what the interviewer is looking for. In other words you must sell what the buyer is buying. This is the single most important strategy in job hunting.

    So, before you answer this or any question it's imperative that you try to uncover your interviewer's greatest need, want, problem or goal.
    To do so, make you take these two steps:
    Do all the homework you can before the hr interview to uncover this person's wants and needs (not the generalized needs of the industry or company)

    As early as you can in the interview, ask for a more complete description of what the position entails. You might say: "I have a number of accomplishments I'd like to tell you about, but I want to make the best use of our time together and talk directly to your needs. To help me do, that, could you tell me more about the most important priorities of this position? All I know is what I (heard from the recruiter, read in the classified ad, etc.)"

    Then, ALWAYS follow-up with a second and possibly, third question, to draw out his needs even more. Surprisingly, it's usually this second or third question that unearths what the interviewer is most looking for.

    You might ask simply, "And in addition to that?..." or, "Is there anything else you see as essential to success in this position?:

    This process will not feel easy or natural at first, because it is easier simply to answer questions, but only if you uncover the employer's wants and needs will your answers make the most sense. Practice asking these key questions before giving your answers, the process will feel more natural and you will be light years ahead of the other job candidates you're competing with.

    After uncovering what the employer is looking for, describe why the needs of this job bear striking parallels to tasks you've succeeded at before. Be sure to illustrate with specific examples of your responsibilities and especially your achievements, all of which are geared to present yourself as a perfect match for the needs he has just described.
    Create Date
    :
    Monday, October 01, 2007
    Asked At
    :
    None
    Job Positions
    :
    Click here to improve the Interview Question, Answer and other fields.
    Comments (3) :
    1.
    Shantanu
    Wednesday, September 17, 2008 10:46 PM
    Hi,
    I am Shantanu and i am a web designer.
    Recently i have launched a website.
    please see this:
    http://www.itportalindia.com
    2.
    priya
    Thursday, August 14, 2008 4:00 AM
    introduce ourself
     
    • More Related Questions: 
    Suggestions & Comments




    Share Your Interview Questions
    Ask Interview Questions
    View Unanswered Questions





    Advertise on this site