org.sourceforge.jxdbcon
Class EscapeFuncs.timestampdiff

java.lang.Object
  |
  +--org.sourceforge.jxdbcon.EscapeFrags.Frag
        |
        +--org.sourceforge.jxdbcon.EscapeFrags.Function
              |
              +--org.sourceforge.jxdbcon.EscapeFuncs.NoFunction
                    |
                    +--org.sourceforge.jxdbcon.EscapeFuncs.timestampdiff

Enclosing class:

EscapeFuncs

public static class EscapeFuncs.timestampdiff

extends EscapeFuncs.NoFunction

TIMESTAMPDIFF(interval, timestamp1, timestamp2) An integer representing the number of interval by which timestamp2 is greater than timestamp1. interval may be one of the following: SQL_TSI_FRAC_SECOND, SQL_TSI_SECOND, SQL_TSI_MINUTE, SQL_TSI_HOUR, SQL_TSI_DAY, SQL_TSI_WEEK, SQL_TSI_MONTH, SQL_TSI_QUARTER, or SQL_TSI_YEAR.

Field Summary

Fields inherited from class org.sourceforge.jxdbcon.EscapeFrags.Function

name, param, paramTypes, retType

Constructor Summary

EscapeFuncs.timestampdiff(EscapeFrags.ParamList param)

Method Summary

protected String	emitSQL(EscapeContext ectx)
String	toSQL(EscapeContext ectx)

Methods inherited from class org.sourceforge.jxdbcon.EscapeFrags.Function

toString

Methods inherited from class org.sourceforge.jxdbcon.EscapeFrags.Frag

simplify

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

EscapeFuncs.timestampdiff

public EscapeFuncs.timestampdiff(EscapeFrags.ParamList param)

Method Detail

emitSQL

protected String emitSQL(EscapeContext ectx)
                  throws SQLException

SQLException

toSQL

public String toSQL(EscapeContext ectx)
             throws SQLException

Overrides:

toSQL in class EscapeFrags.Function

SQLException