Yet another SQL timestamp doubt

HI @knolleary, @Steve-Mcl, @E1cid can anyone guide me with this one?