Time field to a Char Field and make it Military Time

[kernal]

I have a Time field (i.e. 11:23:15.000000PM) and I need to change it to Military time and to a Char field.

Help is appreciated.

Thanks

 

[SkipVought]

hi,

To_Char([Time field],'HH24:MI')

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[kernal]

I'm getting an error " Message=ORA-01722: invalid number." I'm using a query manager tool and I just noticed when I view the statement for that time field that it is using some functions already that I can't change so it looks like the following in the statement:

The functions it is already using that I can't change "TO_CHAR(CAST((time field) AS TIMESTAMP),'HH24.MI.SS.FF')" is giving me the 11:23:15.000000PM output.

Thanks

 

[SkipVought]

So you have no access to time field?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[kernal]

I can create an expression but I can't change any part of "TO_CHAR(CAST((time field) AS TIMESTAMP),'HH24.MI.SS.FF')".

Thanks

 

[kernal]

I got it working "TO_CHAR(TO_DATE(SUBSTR(time field,1,8),'HH24.MI.SS'),'HH24:MI:SS'). Thanks

 

[SantaMufasa]

Kernal,

Out of curiosity, could you please post the field description for TIME?

Thanks,

Mufasa
(aka Dave of Sandy, Utah, USA)
“People may forget what you say, but they will never forget how you made them feel.