Did it once (please keep in mind that I am very much a beginner).
Depends on what kind of rock. I tried using some form of granite, some mixture of chalk and something else, and what I believe to be flint. Flint was the best, but it had too many inclusions (said my "instructor) - whatever those are. Basically, you need either obsidian or good flint and a round, flattish hammerstone. Then you just chip away at an angle to get the edge. Of course, I really sucked at it. Haven't had the chance to try it again.
They don't last all that long except, very specifically, for cutting (mainly the flint, the others were TERRIBLE) - as you cut, the edge slowly deforms as flakes fall off, although to the same extent, it stays fairly sharp longer that way - just the edge becomes more crooked.
Can't open a can of stew - but you could fireharden a sharp wooden stick and use a rock to hammer it open... I suppose. Not something I would want to try though. Might as well just carry a small can opener/multi-tool/SAK - in which case... why bother with making a sharp rock?
IMO, you would have much better luck making a wooden spear, fire-hardening it, and working with that.
Also, certain pieces of bone make fairly decent spear-points and knives - though of course, you need an abrasive rock to work them.