select distinct date question

[seegoon]

Hi to all.
How can I structure a select distinct date command that EXcludes the
time part of the datestamp. If I run a "select distinct date from
dbase" command I get all the records with different times(100's of
records) , I only want the distinct DATES , without associated
times.I'm working in VB.net
Hope I'm making sence.
Thanks
Rob

[Morten Snedker]

On 20 Jul 2005 00:22:36 -0700, "seegoon" <se*******@yahoo.com> wrote:

I don't know against what kind of datasource you're running, but if
using MS-SQL take a look at the Substring method:

SELECT DISTINCT SUBSTRING(myDate,1,10) As ShortDate
FROM myTable

/Snedker

How can I structure a select distinct date command that EXcludes the
time part of the datestamp. If I run a "select distinct date from
dbase" command I get all the records with different times(100's of
records) , I only want the distinct DATES , without associated
times.I'm working in VB.net
Hope I'm making sence.
Thanks
Rob

[seegoon]

Hi there.
It's a ms Access(.mdb) database.
Cheers
Rob

[Morten Snedker]

On 20 Jul 2005 02:07:00 -0700, "seegoon" <se*******@yahoo.com> wrote:

That would be

SELECT DISTINCT Left([myDate],10) AS ShortDate
FROM myTable

Though, you may have to select it into a temp table since Left is a
built-in Access function - not actual SQL-language.

Hi there.
It's a ms Access(.mdb) database.
Cheers
Rob

[seegoon]

Thanks a bunch , got it working now
Thanks again
Rob