I think it works best as a nickname. I like both
Nathan and
Nathaniel, but right now I prefer
Nathan. I don't think
Nate is overused, and even though
Nathan is supposedly quite common, I've only met one.
I also think
Jonathan can work as a full name for
Nate, but it's a stretch.