AnsweredAssumed Answered

DB statement - Static calendar dates

Question asked by Krum_Ganev on Nov 21, 2018
Latest reply on Nov 21, 2018 by Luu Le

Hello,

 

i'm trying to write a DB statement to see the defined dates within all static calendar keywords as it seems some of the .xml exports cannot be reviewed via excel. 

 

so far this is the statement the statement that i came up with:

 

SELECT OH_name, OKB_Name,OKB_CType,OKD_Year, OKD_Content FROM OH LEFT JOIN OKB
ON OH_Idnr = OKB_OH_Idnr
LEFT JOIN OKD
ON OKB_OH_Idnr = OKD_OH_Idnr
WHERE OH_OType like 'CALE'
AND OKB_CType like 'S'
AND OH_Client = 0
AND OH_DeleteFlag = 0

 

result:

CALE.BASE ZSC_NN_PC_SAL_IDD4254F S 2021 111111111111111111111111111111111111111111111111111111111110001111111111111111111111111111111111111111111111111111111111111011111111111111111111111111111111111111111111111111111111111110111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111110111111111111111111111111111111111111111111111111111111111111101111111111111111111111111111111

 

It seems that the dates are defined in bytes. Is there any way to get the dates in human readable format?

Outcomes