Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: formatting month and date
what do you mean with inaccurate?
the date conversion would be something like: to_char(PLAN_S_DATE,'MM/DD/YYYY')
konopam wrote:
> Hello, I was trying to get the date to format as a mm\dd\yyyy but my count
> is inaccurate when doing so, can anyone suggest how to get this with the
> following sql?
>
> SELECT TRUNC(PLAN_S_DATE) as CallDate, Count(PLAN_S_DATE) AS TotalCalls
> FROM ACTIVE_SEPARATE
> WHERE (((ORG_CODE='613')
> OR (ORG_CODE='614')
> OR (ORG_CODE='618')))
> GROUP BY TRUNC(PLAN_S_DATE)
> HAVING TRUNC(PLAN_S_DATE) BETWEEN TO_DATE('&From_Date_MMDDYY','MMDDYY')
> AND TO_DATE('&To_Date_MMDDYY','MMDDYY')
Received on Mon Jul 30 2001 - 14:32:26 CDT