Hi pedro

Thanks for your reply.But that's not what i want.

I want to output the result from tJavaRow.

In fact ,I write a function for datediff ,having a precision of day. Be different from java datediff, I need to keep the date and ignore the time.

My function:
    public static long dateDiff(Date issueDate,Date originalInvoiceDate){
          
            if (issueDate == null) {
                issueDate = new Date(0);
            }
            if (originalInvoiceDate == null) {
                originalInvoiceDate = new Date(0);
            }
                long day1 = issueDate.getTime()/1000/60/60/24;
                long day2 = originalInvoiceDate.getTime()/1000/60/60/24;
                long day = (day1-day2);
                return day;
    }
It always return a result with one day differnt from the result given by MS SQL datediff


Joe