Any idea if I can take Uber to Davis and how much it costs from SMF airport at noontime?
Why would you NOT be able to take an Uber? It is a 25-minute drive. An UberX would cost you $30.
A low-cost alternative is to take Yolo Bus 42A or 42B. Same route different directions. A few dollars. One bus per hour. Which A or B is better to take depends on where in Davis you want to go to.