Rapid onset of molecular friction in liquids bridging between the atomistic and hydrodynamic pictures