How to use order by clause for time?

Question

User-1148373670 posted

Hi,

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.

Answer 1

User1577733570 posted

Hi,

If you are not making any conversion to the DateTime field, then
it will sort the date part as well as the time part.

Answer 2

User1927273029 posted

Hello,

Do not convert the datetime to any other data type and use normal ordering. It will order time by itself

Answer 3

User-1148373670 posted

I got solution.

Thanks All