Do you mean the time first/last received for the AIRCRAFT or the FLIGHT on that day.
For the aircraft, there's 2 fields you could add - Aircraft.LastTime and Aircraft.FirstTime:
.output data.html
.mode list
.header OFF
SELECT DISTINCT "<HTML><HEAD><Title>Radarbox Log - Yesterday</Title>" AS FIELD_1 FROM Aircraft;
SELECT DISTINCT "<STYLE type='text/css'> BODY { background: #000000; color: #FFFFFF; font-family: Arial; }</STYLE>" AS FIELD_1 FROM Aircraft;
SELECT DISTINCT "</HEAD><BODY>" AS FIELD_1 FROM Aircraft;
SELECT DISTINCT "<Table Border='1' Cellpadding='4' Cellspacing='1'>" AS FIELD_1 FROM Aircraft;
.mode html
.header ON
SELECT DISTINCT Aircraft.LastTime AS "Last Time",Aircraft.FirstTime AS "First Time",Aircraft.Registration AS "Reg",Flights.Callsign AS "Flight ID",Flights.Route AS "Route",Aircraft.AircraftTypeSmall AS "ICAO Type",Aircraft.Airline AS "Airline",Aircraft.AircraftTypeLong AS "Aircraft",substr(Flights.EndTime,1,16) AS "Flight Ended",Aircraft.ModeS AS "Mode S" FROM Aircraft LEFT OUTER JOIN Flights ON (Aircraft.ModeS=Flights.ModeS) WHERE ((date('now','-1 day') = substr(Aircraft.LastTime,1,4)||"-"||substr(Aircraft.LastTime,6,2)||"-"||substr(Aircraft.LastTime,9,2)) AND (Flights.StartTime IS NULL)) OR ((date('now','-1 day') = substr(Flights.EndTime,1,4)||"-"||substr(Flights.EndTime,6,2)||"-"||substr(Flights.EndTime,9,2))) ORDER BY Aircraft.Registration,Flights.EndTime,Aircraft.ModeS;
.mode list
.header OFF
SELECT DISTINCT "</Table></BODY></HTML>" AS FIELD_1 FROM Aircraft;
.exit
Complete list of fields available in MyLog:
Aircraft.Comment,
Aircraft.LastTime,
Aircraft.FirstTime,
Aircraft.AircraftTypeLong,
Aircraft.AircraftTypeSmall,
Aircraft.Airline,
Aircraft.ModeS,
Aircraft.ModeSCountry,
Aircraft.Registration,
Aircraft.ADSB,
Flights.Callsign,
Flights.EndTime,
Flights.ModeS,
Flights.MsgCount,
Flights.Registration,
Flights.Session,
Flights.StartTime,
Flights.StartPosition,
Flights.EndPosition,
Flights.StartAltitude,
Flights.EndAltitude,
Flights.StartGS,
Flights.EndGS,
Flights.Route
