Displays date but not time

[nabh4u]

Hi all,

I have problem in displaying time. it only displays date but not time.
i am using
DECODE(PROC_TM,'999999', NULL,PROC_TM) proc_tm
and then
PROC_TME = TO_DATE(C2.PROC_TM, 'HH24MISS')

It only displays date but not the time. what should i do?

And in another procedure i have time displayed but not properly
like 10:40 is displayed as 1040 (10 min and 40 seconds).
what should i do in this?

any advice will be accepted.
thank you all,

nabh4u

[Dave44]

Hi all,

I have problem in displaying time. it only displays date but not time.
i am using
DECODE(PROC_TM,'999999', NULL,PROC_TM) proc_tm
and then
PROC_TME = TO_DATE(C2.PROC_TM, 'HH24MISS')

It only displays date but not the time. what should i do?

And in another procedure i have time displayed but not properly
like 10:40 is displayed as 1040 (10 min and 40 seconds).
what should i do in this?

any advice will be accepted.
thank you all,

nabh4u

If you are displaying a date you need to format it with to_char not to_date, the latter is used for turning a string to an oracle date.

[holdingbe]

If you are displaying a date you need to format it with to_char not to_date, the latter is used for turning a string to an oracle date.

HI friend,

select to_char(sysdate,'HH24:MISS')
from dual


please do like that

Regards
Mihael

[nabh4u]

If you are displaying a date you need to format it with to_char not to_date, the latter is used for turning a string to an oracle date.

I am afraid but the solution you provided to my problem doesnt work. it still displays the same date format but no time is displayed.
what should i do now?

[debasisdas]

please try the sample code

select to_char(sysdate,'HH24:MI:SS') from dual

hope that solves your problem.

[nabh4u]

please try the sample code

select to_char(sysdate,'HH24:MI:SS') from dual

hope that solves your problem.

No..even that doesnt work.

[debasisdas]

How is that possible ?

Can you kindly post your code for my reference please.

[nabh4u]

How is that possible ?

Can you kindly post your code for myb reference please.

I am sorry i cant provide the code because of company rules. I tried to provide as much information as possible.
i am really very sorry. but thanks for helping me.

[debasisdas]

Ok ,i can understand the problem.

Better you follow some good books / materials .

wishing you best of luck.

[nabh4u]

Ok ,i can understand the problem.

Better you follow some good books / materials .

wishing you best of luck.

thank you very much for all the support.