I need to get the max date from a table, The date field in the table is Date/Time. So, if I run the following query will both date and time be considered in looking for MAX date. I other words, would I get the Max date and time. Concerned that if query is run, and then another record is added after that, and the query is run again on the same day.
Thanks
Code:
SELECT Max(Mastertbl3.calldate) AS MaxOfcalldate
FROM Mastertbl3;
Thanks