"Re: Sorting dates with NULL values"

[Johan Koelewijn]

Bert,

Maybe create a defined item with zeroes when there is a null value and sort on that defined item ?

Johan
Van Dijk Delft BV

> Hi All,
> 
> We have a problem with the order of date fields with NULL values.
> We are running PH820 with Oracle RDBMS with NULL value support.
> In a cluster screen we would like to have a primary file ordered by a date
> field in the following order:
>   Null values first, existing dates ordered ascending
>   but order by ascending or descending does not help us out
> 
> 
> 
> Ascending        Descending		What we want
> ----------------------------------------------------------
> 2000/12/01       NULL               NULL
> 2000/12/02       2000/12/31         2000/12/01
> 2000/12/31       2000/12/02         2000/12/02
> NULL             2000/12/01         2000/12/31
> 
> 
> Any ideas?
> 
> 
> Kindest regards,
> Arma bv
> 
> 
> 
> Bert de Nooij
> Einsteinbaan 4
> 3439 NJ Nieuwegein
> mailto:Bert.DN@Arma.com
> http://www.arma.com
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> This list is closed, thus to post to the list, you must be a subscriber.
> 


= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.