Package com.streambase.sb

Class Timestamp

  • All Implemented Interfaces:
    Serializable, Comparable<Timestamp>
    public class Timestamp
extends Object
implements Comparable<Timestamp>, Serializable
    This class represents a Streambase Timestamp. The timestamp can be of two different types: An interval or an offset since the epoch, January 1, 1970 00:00:00.000 GMT (Gregorian).

    Note: Serializations of instances of this class that are created (e.g., by using ObjectOutputStream) in one version of StreamBase in general will not be deserializable in any other version of StreamBase.

    See Also:
    Serialized Form

    • Field Summary

      Fields 
      Modifier and Type Field Description
      static String DATE_FORMAT
      The default format for date and time formatting and parsing used by StreamBase: "yyyy-MM-dd HH:mm:ss.SSSZ"
      static String DATE_FORMAT_NO_TIMEZONE
      The default format for date and time formatting and parsing used by StreamBase when the timezone is to be ignored: "yyyy-MM-dd HH:mm:ss.SSS"
      static long INTERVAL
      Timestamps can be timestamps or intervals.
      static DecimalFormat INTERVAL_FORMAT
      Format of a timestamp interval
      static long TIMESTAMP
      Timestamps can be timestamps or intervals.

    • Constructor Summary

      Constructors 
      Constructor Description
      Timestamp​(Date date)
      Create a Timestamp out of a java.util.Date

    • Field Detail

      • TIMESTAMP

        public static final long TIMESTAMP
        Timestamps can be timestamps or intervals. TIMESTAMP indicates that this is a TIMESTAMP
        See Also:
        Constant Field Values

      • INTERVAL

        public static final long INTERVAL
        Timestamps can be timestamps or intervals. INTERVAL indicates that this is an INTERVAL
        See Also:
        Constant Field Values

      • INTERVAL_FORMAT

        public static final DecimalFormat INTERVAL_FORMAT
        Format of a timestamp interval

      • DATE_FORMAT

        public static final String DATE_FORMAT
        The default format for date and time formatting and parsing used by StreamBase: "yyyy-MM-dd HH:mm:ss.SSSZ"
        See Also:
        Constant Field Values

      • DATE_FORMAT_NO_TIMEZONE

        public static final String DATE_FORMAT_NO_TIMEZONE
        The default format for date and time formatting and parsing used by StreamBase when the timezone is to be ignored: "yyyy-MM-dd HH:mm:ss.SSS"
        See Also:
        Constant Field Values

    • Constructor Detail

      • Timestamp

        public Timestamp​(Date date)
        Create a Timestamp out of a java.util.Date
        Parameters:
        date - a java.util.date

    • Method Detail

      • msecs

        public static Timestamp msecs​(long type,
                              long ms)
        Create a timestamp using the following type and # of milliseconds
        Parameters:
        type - either INTERVAL or TIMESTAMP
        ms - An instant in time represented by a millisecond value that is an offset from the Epoch, January 1, 1970 00:00:00.000 GMT (Gregorian).
        Returns:
        the Timestamp

      • msecs

        public static Timestamp msecs​(long type,
                              double ms)
        Create a timestamp using the following type and # of milliseconds
        Parameters:
        type - either INTERVAL or TIMESTAMP
        ms - An instant in time represented by a millisecond value that is an offset from the Epoch, January 1, 1970 00:00:00.000 GMT (Gregorian).
        Returns:
        the Timestamp

      • secs

        public static Timestamp secs​(long type,
                             long secs)
        Create a timestamp using the following type and # of seconds
        Parameters:
        type - either INTERVAL or TIMESTAMP
        secs - An instant in time represented by a second value that is an offset from the Epoch, January 1, 1970 00:00:00.000 GMT (Gregorian).
        Returns:
        the Timestamp

      • secs

        public static Timestamp secs​(long type,
                             double secs)
        Create a timestamp using the following type and # of seconds
        Parameters:
        type - either INTERVAL or TIMESTAMP
        secs - An instant in time represented by a second value that is an offset from the Epoch, January 1, 1970 00:00:00.000 GMT (Gregorian).
        Returns:
        the Timestamp

      • now

        public static Timestamp now()
        Create a timestamp using the current time
        Returns:
        the Timestamp

      • fromString

        public static Timestamp fromString​(CharSequence dateString)
                            throws StreamBaseException
        Create a timestamp using the given string
        Parameters:
        dateString - string containing a date/time, or an interval. date/time format: "YYYY-MM-DD HH:MM:SS.SSS+TTTT". For example, "2005-01-07 11:09:37.000-0500" where -0500 indicates Eastern Standard Time. The timezone is optional, as are the fractional seconds. Interval format: "SS.SSS", seconds and fractional seconds
        Returns:
        the Timestamp
        Throws:
        StreamBaseException - when unable to parse as a timestamp
        Since:
        6.5

      • fromString

        public static Timestamp fromString​(String dateString)
                            throws StreamBaseException
        Create a timestamp using the given string
        Parameters:
        dateString - string containing a date/time, or an interval. date/time format: "YYYY-MM-DD HH:MM:SS.SSS+TTTT". For example, "2005-01-07 11:09:37.000-0500" where -0500 indicates Eastern Standard Time. The timezone is optional, as are the fractional seconds. Interval format: "SS.SSS", seconds and fractional seconds
        Returns:
        the Timestamp
        Throws:
        StreamBaseException - when unable to parse as a timestamp

      • fromString

        public static Timestamp fromString​(String dateString,
                                   CSV.FormatInfo format)
                            throws StreamBaseException
        Create a timestamp using the given string and format. Assumption: If format is present, the dateString may not represent an interval
        Parameters:
        dateString - Date string
        format - Format
        Returns:
        a timestamp Timestamp value
        Throws:
        StreamBaseException - Error creating timestamp

      • isInterval

        public boolean isInterval()
        Returns true if this is an interval timestamp; false otherwise
        Returns:
        true if an interval type

      • getType

        public long getType()
        Return the current type of timestamp
        Returns:
        the current type of the timestamp (INTERVAL or TIMESTAMP)

      • toDate

        public Date toDate()
        Create a java.util.Date
        Returns:
        a java.util.Date

      • toSQLDate

        public Date toSQLDate()
        Create a java.sql.Date
        Returns:
        a java.sql.Date

      • toSQLTimestamp

        public Timestamp toSQLTimestamp()
        Create a java.sql.Timestamp
        Returns:
        a java.sql.Timestamp

      • toMsecs

        public long toMsecs()
        Return the # of milliseconds since the epoch or in the interval
        Returns:
        Milliseconds

      • toSecs

        public long toSecs()
        Return the # of seconds since the epoch or in the interval
        Returns:
        Seconds

      • toString

        public String toString​(boolean includeTimezone)
        Create string representation of this timestamp, optionally include timezone
        Parameters:
        includeTimezone - include the timezone?
        Returns:
        String representaion of this timestamp

      • toString

        public String toString()
        Create string representation of this timestamp with the timezone
        Overrides:
        toString in class Object
        Returns:
        String representaion of this timestamp