Forum Discussion

RohitBorse's avatar
RohitBorse
New Contributor
3 years ago
Solved

How to send oracle to_date function in groovy sql.call.

How to send oracle to_date function in groovy sql.call.

to_date('2021-04-28-00.00.00','YYYY-MM-DD-HH24.MI.SS','NLS_CALENDAR=GREGORIAN')

  • Ok, I have done something below

     

    import groovy.sql.Sql;
    import groovy.sql.GroovyRowResult;

     

    GroovyRowResult row = sql.firstRow("SELECT to_date('2021-04-28-00.00.00','YYYY-MM-DD-HH24.MI.SS','NLS_CALENDAR=GREGORIAN') AS MyDate FROM DUAL");
    def MyDate= row.MyDate;

    String RESULT = "";
    sql.call( "{call MYAPP.MYDATE.UPDATE_DATE(?, ?)}", [ sql.inout(Sql.VARCHAR(RESULT), MyDate])

    {OUT1 ->

    RESULT = OUT1;

    }

1 Reply

  • RohitBorse's avatar
    RohitBorse
    New Contributor

    Ok, I have done something below

     

    import groovy.sql.Sql;
    import groovy.sql.GroovyRowResult;

     

    GroovyRowResult row = sql.firstRow("SELECT to_date('2021-04-28-00.00.00','YYYY-MM-DD-HH24.MI.SS','NLS_CALENDAR=GREGORIAN') AS MyDate FROM DUAL");
    def MyDate= row.MyDate;

    String RESULT = "";
    sql.call( "{call MYAPP.MYDATE.UPDATE_DATE(?, ?)}", [ sql.inout(Sql.VARCHAR(RESULT), MyDate])

    {OUT1 ->

    RESULT = OUT1;

    }