Skip to main content
ExLibris
  • Subscribe by RSS
    • Back
    Aleph
    Ex Libris Knowledge Center

    Translating due date from the Z31-KEY field

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    I am running cash-02 to generate a list of patrons billed for lost items. I would like to include the due date for this items in the report, and I see that information is contained in the Z31-KEY field that is part of the XML data.

    How can I translate that field to make it look nice for the report? I would like to be able to display bytes 63-70.

    Resolution:
    Here is an example of SQL to format Aleph yyyymmdd dates:

    usm50@ALEPH201> select to_date (z36_loan_date, 'YYYY/MM/DD') from z36;

    And here is specific SQL for the Z31-KEY due date:

    usm50@ALEPH201> select to_date (substr (z31_key,63,8), 'YYYY/MM/DD') from z31;

    • Article last edited: 10/8/2013