Dates & Times in SQL
It is very easy for people new to SQL to get caught out by dates that contain times, e.g. the getdate() function which returns the current date and time. For example a travel company might have a Booking table with a column BookingDate which just contains the date (not time) that a booking was made.
Read more