Day tours are tours that last fewer than 24 hours.
( Excursion ) excursionist = A traveler spending less than 24 hours in a country.
City tours, are a city guide that point out the interesting sights (most likely historical or architectural) usually conducted via motorcoach, minibus, van, or as part of a walking tour.