Skip to Content
avatar image
Former Member

OINV.createTS format hh:mm:ss

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 21, 2017 at 11:24 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 21, 2017 at 11:45 AM

    oh my God,

    I was really near the end :-).

    Thank you, Johan,

    regards

    martina

    Add comment
    10|10000 characters needed characters exceeded