Skip to main content
ExLibris

 

  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Concatenate Date and Time Fields in ISO 8601 Format

    Created By: Igelu-Eluna Analytics
    Created on: 4/29/2020



    Formula

    TO_DATETIME(CAST("Loan Date"."Loan Date" as CHAR)||' '||CAST("Loan Date"."Loan Time" as CHAR), 'dd-mon-yy hh:mi:ss')

    Column Properties > Data Format = Custom, and

    yyyy/MM/ddTHH:mm:ssZ 
     


    IGeLU-ELUNA Analytics Working Group / Analytics Working Group Listserv




    • Was this article helpful?