The description of the Sweet Dreams advancement clearly states to change your respawn location, which is now possible during the day. However, you only get the advancement by actually sleeping in a bed.