Last post Sep 07, 2011 01:43 AM by info2ambrish
Sep 07, 2011 12:59 AM|info2ambrish|LINK
I am using oracle database and in database i have one column appdate that contain date with time.
I have five records with same date but timing is diffrent.
How to write a oracle query to orader the data based on timing asc and dsc order.
Please provide some query and solve my issue.
thanks in advance.
Sep 07, 2011 01:20 AM|leena.d.patil|LINK
If you are not making any conversion to the DateTime field, then
it will sort the date part as well as the time part.
Sep 07, 2011 01:30 AM|jassi_singh|LINK
Do not convert the datetime to any other data type and use normal ordering. It will order time by itself
Sep 07, 2011 01:43 AM|info2ambrish|LINK
I got solution.