Post reply

sql queries

  • January 21, 2011 at 6:47 am

    #230701

    i need nearest saturday from the current date, please tell the answer.

    nani

  • January 21, 2011 at 6:53 am

    #1276518

    please read and follow the instructions given in the first link in my signature.

    You might also search either this site or Google for a solution. This is a rather common question.

    But to answer your question at the same level: You need to use DATEDIFF() with the proper arguments. 😉


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • January 21, 2011 at 6:59 am

    #1276520

    So what's the question?

  • January 22, 2011 at 8:24 am

    #1276898

    FLOOR(DATEDIFF(day, DateOfBirth, GETDATE()) / 365.25)

  • January 22, 2011 at 11:23 am

    #1276914

    sungiri88 (1/22/2011)

    FLOOR(DATEDIFF(day, DateOfBirth, GETDATE()) / 365.25)

    What is the with the division? The question was to display the age in days:

    datediff(dd, dob, getdate())) -- How many days between now and the date of birth.

  • January 23, 2011 at 10:32 pm

    #1277046

    thank you friend for ur help.

    nani

Viewing 6 posts - 1 through 6 (of 6 total)

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