Professional Web Applications Themes

average function - MySQL

Hello, I am trying to find the average age of all customers from the customer table. I tried "select avg(current_date - dob) from customer;" and it gives me this result 101527.54927986 I would like the value in years. Would be really thankful if somebody could help me with this. Thanks ros CREATE TABLE `my_database`.`customer` ( `CUST_ID` int(11) default NULL, `FIRST_NAME` varchar(50) default NULL, `LAST_NAME` varchar(50) default NULL, `DOB` date default NULL, `ADDRESS_LINE1` varchar(50) default NULL, ) ENGINE=InnoDB DEFAULT CHT=latin1;...

  1. #1

    Default average function

    Hello,

    I am trying to find the average age of all customers from the customer
    table.
    I tried

    "select avg(current_date - dob) from customer;"

    and it gives me this result

    101527.54927986

    I would like the value in years. Would be really thankful if somebody
    could help me with this.
    Thanks
    ros





    CREATE TABLE `my_database`.`customer` (
    `CUST_ID` int(11) default NULL,
    `FIRST_NAME` varchar(50) default NULL,
    `LAST_NAME` varchar(50) default NULL,
    `DOB` date default NULL,
    `ADDRESS_LINE1` varchar(50) default NULL,
    ) ENGINE=InnoDB DEFAULT CHT=latin1;

    ros Guest

  2. #2

    Default Re: average function

    ros wrote: 

    What about
    select avg(YEAR(current_date) - YEAR(dob)) from customer


    Paul Guest

  3. #3

    Default Re: average function

    On Apr 11, 3:43 pm, "Paul Lautman" <com>
    wrote: 






    >
    > What about
    > select avg(YEAR(current_date) - YEAR(dob)) from customer[/ref]

    Yes that's what I wanted. Got confused! Thanks
    Ros

    ros Guest

Similar Threads

  1. average
    By Lawrence in forum FileMaker
    Replies: 4
    Last Post: February 13th, 12:36 AM
  2. average using lingo
    By bright_lightsuk in forum Macromedia Director Lingo
    Replies: 0
    Last Post: November 11th, 11:59 AM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139