Re: Help: Using break on date-field

From: Alan D. Mills <alanm_at_uk.europe.mcd.mot.com>
Date: Tue, 24 Nov 1998 09:29:23 -0000
Message-ID: <73du7s$o2j$1@schbbs.mot.com>

It's probably because you have a timestamp within your date column.

Display your dates in whichever format you're comfortable with but order by TRUNC(date_column) and then by code_column. That should do it.

--
Alan D. Mills

Peter Bishop wrote in message <3659EF1F.C9F3026C_at_nortel.com>...
>
>I've been using the following code:
>
>> break on date skip 0 dup on text skip 0 dup
>> select date, text from table order by date, text;
>
>The results are grouped by the date value but I get the 'A' and 'B'
>values distributed throughout the date groupings.
>
>
>Responses by email would be appreciated.
>
>Thanks.
Received on Tue Nov 24 1998 - 03:29:23 CST