I have a table with about 500,000 records.
It appears it was setup with a Auto-Enter Creation Date & Time field.
What is the easiest way to extract only the date....
GetasDate (YourTimestampfield here)
Depending what your requirement is you may not even have to actually extract it, just use it. For example, it is possible to perform a date-based find in a timestamp field, so if all you need is to be able to use this field to find records that were created on a certain day, or within a certain period this kind of Find may be all you need.
Retrieving data ...