Thanks mccork,

i am getting results in correct format..i mean date format. But that column is not ordered in asc/desc, according my requirement.

Thanks,

sekhar

Edited by - k_sekhar_rao on 07/10/2003 05:02:03...