| unable to sort date function [message #291637] |
Sat, 05 January 2008 10:43  |
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
|
Senior Member |
|
|
hello sir,
i m having a query in which date function is sorted by
order by to_date(document_date) desc. which works fine on toad
but when that query run on report it will fail to sort.
date column comes hapazardly.
then i edit on registry of application server as nls_date_format 'DD-MMM-YYYY' but nothing going to hapen.
on that field's property i found date database length as 9.
i unable to recognise from where it come, even i format date mask as dd-mm-yyyy but no conclusion.
sir please help me how could i do to sort it.
Regards
|
|
|
|
| Re: unable to sort date function [message #291641 is a reply to message #291637] |
Sat, 05 January 2008 10:58  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
|
Open Property Inspector window for the 'document_date' field and set its 'Break Order' property to 'Ascending'. Also, you might want to take care about field order in its group.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
