select distinct date from datetime field
Posted: Sat Mar 19, 2005 11:49 am
I have a table that has a field that stores datetime. I would like to run a query that would return distinct dates (days).
For instance, if the field was a date field I would use the following query:
"Select distinct(mydate) from my_table"
For instance, if the field was a date field I would use the following query:
"Select distinct(mydate) from my_table"