Unique Dates and TRUNC

[jcs1953]

I have this query:

SELECT ( REQ_PANELS.RUN_DATE) "Start_Date" FROM REQ_PANELS, REQUISITIONS, RESULTS, TESTS WHERE REQUISITIONS.ACC_ID = REQ_PANELS.ACC_ID AND REQ_PANELS.RP_ID = RESULTS.RP_ID AND RESULTS.TEST_ID = TESTS.TEST_ID AND (REQUISITIONS.PAT_ID = '10364.0') AND (REQ_PANELS.RUN_DATE IS NOT NULL) ORDER BY REQ_PANELS.RUN_DATE

This returns a list of dates and times (38 of them). If I modify the query with TRUNC like this:

SELECT TRUNC ( REQ_PANELS.RUN_DATE) "Start_Date" FROM REQ_PANELS, REQUISITIONS, RESULTS, TESTS WHERE REQUISITIONS.ACC_ID = REQ_PANELS.ACC_ID AND REQ_PANELS.RP_ID = RESULTS.RP_ID AND RESULTS.TEST_ID = TESTS.TEST_ID AND (REQUISITIONS.PAT_ID = '10364.0') AND (REQ_PANELS.RUN_DATE IS NOT NULL) ORDER BY REQ_PANELS.RUN_DATE

I then get a list of just dates (again 38). If I modify the query with UNIQUE like this:

SELECT UNIQUE ( REQ_PANELS.RUN_DATE) "Start_Date" FROM REQ_PANELS, REQUISITIONS, RESULTS, TESTS WHERE REQUISITIONS.ACC_ID = REQ_PANELS.ACC_ID AND REQ_PANELS.RP_ID = RESULTS.RP_ID AND RESULTS.TEST_ID = TESTS.TEST_ID AND (REQUISITIONS.PAT_ID = '10364.0') AND (REQ_PANELS.RUN_DATE IS NOT NULL) ORDER BY REQ_PANELS.RUN_DATE

I get 10 rows of unique Date/Time (although not unique dates).
What I need is a list of UNIQUE TRUNC dates but I can't fiqure out how to word the query.
Any ideas?
Thanks

 

[jcs1953]

Fiqured it out. I needed to change "ORDER BY REQ_PANELS.RUN_DATE" to "Order by 1

 

[ChrisHunt]

SELECT [red]DISTINCT[/red] TRUNC(run_date)
FROM your_tables_here

-- Chris Hunt
Webmaster & Tragedian
Extra Connections Ltd

 

[Beilstwh]

and you also could have used
order by trunc(REQ_PANELS.RUN_DATE)

Bill
Lead Application Developer
New York State, USA