Sql Date and Time doubt

[rsrinivasan]

My Oracle table "sav" structure is

order_entry_dat e ---- date
order_entry_tim e ---- varchar2(10)

select to_date(order_e ntry_date||' '||order_entry_ time, 'DD-Mon-YY HH12:MI am') as dates
from sav;


Result:

DATES
---------

01-JAN-07
01-JAN-07
01-JAN-07
01-JAN-07

I did not get Time..
i do not know what is the reason for it..
Anybody can help me.. plz...

[debasisdas]

First of all tell me why u need two different field to store date and time while u can u the same using a single field with data type date.
In your case u dont need the second field at all.

[rsrinivasan]

First of all tell me why u need two different field to store date and time while u can u the same using a single field with data type date.
In your case u dont need the second field at all.

thanks for ur reply...
Actually i have modified one project which has two fields to store date and time.
As per the client requirement, i need to concat these fields.

[chandu031]

Hi,

If you need a timestamp output, use the TO_TIMESTAMP function instead of to_date.