There are two distinct but closely related factors here. The temperature in the habitat waters (nature) and the temperature variations in the aquarium.
Taking the latter first, in especially larger tanks the water will always be cooler above the substrate than it will near the surface. This mimics habitat waters, but in the aquarium the water is drawn down through the substrate where the decomposition process warms it, and the warmer water then rises back up into the aquarium. I don't have numbers, but this is a fairly slow process. The water near the substrate will be cooler. In my 70g, 90g and 115g tanks this was quite noticeable when I had my hand down at the substrate rearranging plants or whatever. People suggest having internal heaters horizontal and close to the substrate so the water is warmed and naturally rises. Having the filter return very close to the heater is always advisable so the warmed water circulates. It also saves the heater...the constantly warm water around the heater will cause it to go off more, and on and off more, which wears it out faster.
A diurnal variation is sometimes suggested, achieved by two sets of heaters set at slightly different temperatures and on timers so the warmer ones are on during the day and the lower temperature heaters during darkness. We had some threads on this a couple of years back. I don't hear much about this any more, but if not taken to extreme it should be practical.
Which brings me to habitat water temperature. In tropical watercourses, the variation between day and night water temperatures is no where near what some may assume. A couple degrees, sometimes not even that. It depends upon the circumstances. Water retains heat longer than air. And the forest floor retains heat too. These together result in minimal if any temperature fluctuation diurnally. And season variation is almost non-existent. The rainy season will bring cooler water, sometimes and maybe. The air is very warm above the organic forest floor, and the heat will affect falling rainwater.
In their data on the habitat of Mikrogeophagus ramirezi, Linke & Staeck (1994) noted that on an overcast day, at 10 am in the morning, the water was 28.5 C (83F) and the air was still "relatively cool" at 31C (88F).