4/3/2023 0 Comments Utime function c![]() JDE also provided the attached document on how to use these functions. JdeUTime_ConvertFromJDEDate() - to convert from DATE to UTIME JdeUTime_ConvertToJDEDate() - to convert from UTIME to DATE They can map the JDEUTIME back and forth to the JDEDATE structure with the following APIs. Therefore an application that uses JDB_OpenForeignTable with the DATE column would have to use the JDEUTIME as a data structure. The decision was made to go with JDEUTIME since JDEUTIME can store more information including the time. Now, when JDB_OpenForeignTable sees this DATE column, it does not know whether it is a JDEDATE or JDEUTIME. In the Oracle database the JDEDATE (non-julian) and JDEUTIME items are stored in the same format which is DATE. In EnterpriseOne 8.10 it only works in the same way when the JDEDATE data structure is replaced with JDEUTIME data structure. This worked successfully with EnterpriseOne release Xe. Subsequent reads of a date column do not correctly populate the JDEDATE data structure. In a custom C business function, an Oracle table has been successfully opened as a foreign table using JDB_OpenForeignTable. SOLUTION ID: 200996029 E1: BSFN: Unable to Access Foreign Table Date Column using API in 8.9 and Beyond I suggest, if you can reproduce this error, that this is a bug which you could solve in a future version.įurther to this case, I've found my whole UBE aborts when executing utc_get_year Time Zone function where the Utime parameter is NULL – so I’ve made sure this is never NULL. I have therefore had to write repeated code for each date. method:: utime.sleepms (ms) Delay for given number of milliseconds, should be positive or 0. You can use a floating-point number to sleep for a fractional number of seconds, or use the :func:utime.sleepms () and :func:utime.sleepus () functions. I tested some NER code to extract each date element, however, when I created a NER business function, I found the Utime parameter, though populated when passed in, was blank inside the function. method:: utime.sleep (seconds) Sleep for the given number of seconds. Somehow (our administrators don't (but would like to) know how) extra ones have appeared which I can use to solve the problem: before there was only utc_get_year now there's utc_get_year, utc_get_month all the way down to utc_get_second! Now I can convert the dates. For some reason, when I initially tried to follow the document found on your website (attached), the only Time Zone Functions listed in Expression Manager were the ones in the document. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |