Skip to Content
0

OINV.createTS format hh:mm:ss

Feb 21, 2017 at 09:48 AM

60

avatar image
Former Member

Hello,

please, could you help me with creating formatted search in OINV documents ? I would need to show OINV.CreateTS in format hh:mm:ss. Now it is only in format hhmmss. I´m able to convert it , but I cannot display the right value for only one OINV.DocNum.

SELECT STUFF(STUFF(STUFF(T0.CreateTS, 1, 0, REPLICATE('0', 6 - LEN(T0.createTS))),3,0,':'),6,0,':') from OINV T0

Thank you, regards

Martina

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Johan Hakkesteegt Feb 21, 2017 at 11:24 AM
0

Hi Martina,

You can use the formatted search parameter format:

select STUFF(STUFF(STUFF(T0.CreateTS, 1, 0, REPLICATE('0', 6 - LEN(T0.createTS))),3,0,':'),6,0,':') 
from OINV T0
where T0.DocNum = $[OINV.DocNum]

Regards,

Johan

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 21, 2017 at 11:45 AM
0

oh my God,

I was really near the end :-).

Thank you, Johan,

regards

martina

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Martina,

Glad I could help.

Please close this question by selecting a best answer.

Regards,

Johan

0