/** time stamp diff */ public static String sqltimestampdiff(List parsedArgs) throws SQLException{ if (parsedArgs.size()!=3){ throw new PSQLException(GT.tr("{0} function takes three and only three arguments.","timestampdiff"), PSQLState.SYNTAX_ERROR); } String datePart = EscapedFunctions.constantToDatePart(parsedArgs.get(0).toString()); StringBuffer buf = new StringBuffer(); buf.append("extract( ").append(datePart) .append(" from (").append(parsedArgs.get(2)).append("-").append(parsedArgs.get(1)).append("))"); return buf.toString(); }
/** time stamp diff */ public static String sqltimestampdiff(List parsedArgs) throws SQLException{ if (parsedArgs.size()!=3){ throw new PSQLException(GT.tr("{0} function takes three and only three arguments.","timestampdiff"), PSQLState.SYNTAX_ERROR); } String datePart = EscapedFunctions.constantToDatePart(parsedArgs.get(0).toString()); StringBuffer buf = new StringBuffer(); buf.append("extract( ").append(datePart) .append(" from (").append(parsedArgs.get(2)).append("-").append(parsedArgs.get(1)).append("))"); return buf.toString(); }
/** time stamp diff */ public static String sqltimestampdiff(List parsedArgs) throws SQLException{ if (parsedArgs.size()!=3){ throw new PSQLException(GT.tr("{0} function takes three and only three arguments.","timestampdiff"), PSQLState.SYNTAX_ERROR); } String datePart = EscapedFunctions.constantToDatePart(parsedArgs.get(0).toString()); StringBuffer buf = new StringBuffer(); buf.append("extract( ").append(datePart) .append(" from (").append(parsedArgs.get(2)).append("-").append(parsedArgs.get(1)).append("))"); return buf.toString(); }