Diurnal tide in the upper atmosphere