org.hsqldb

Class HsqlDateTime

java.lang.Object

org.hsqldb.HsqlDateTime

public class HsqlDateTime
extends java.lang.Object

collection of static methods to convert Date and Timestamp strings into corresponding Java objects and perform other Calendar related operation.

Was reviewed for 1.7.2 resulting in centralising all DATETIME related operstions.

From version 2.0.0, HSQLDB supports TIME ZONE with datetime types. The values are stored internally as UTC seconds from 1970, regardless of the time zone of the JVM, and converted as and when required, to the local timezone.

Since:

1.7.0

Field Summary

Fields

Modifier and Type	Field and Description
static java.util.Calendar	tempCalDefault
static java.util.Calendar	tempCalGMT

Constructor Summary

Constructors

Constructor and Description
HsqlDateTime()

Method Summary

Modifier and Type	Method and Description
static long	convertMillisFromCalendar(java.util.Calendar calendar, long millis)
static long	convertMillisToCalendar(java.util.Calendar calendar, long millis)
static long	convertToNormalisedDate(long t, java.util.Calendar cal)
static long	convertToNormalisedTime(long t)
static long	convertToNormalisedTime(long t, java.util.Calendar cal)
static long	getCurrentDateMillis(long millis)
static long	getDateSeconds(java.lang.String s)
static java.lang.String	getDateString(long seconds)
static int	getDateTimePart(long m, int part) Returns the indicated part of the given millisecond date object.
static long	getNormalisedDate(java.util.Calendar cal, long d)
static long	getNormalisedDate(long d)
static long	getNormalisedTime(java.util.Calendar cal, long t)
static long	getNormalisedTime(long t)
static long	getRoundedPart(long m, int part) rounded millisecond date object
static java.lang.String	getSystemTimeString()
static long	getTimeInMillis(java.util.Calendar cal) Gets the time from the given Calendar as a milliseconds value; wrapper method to allow use of more efficient JDK1.4 method on JDK1.4 (was protected in earlier versions).
static long	getTimestampSeconds(java.lang.String s)
static java.lang.String	getTimestampString(long millis)
static void	getTimestampString(java.lang.StringBuffer sb, long seconds, int nanos, int scale)
static long	getTruncatedPart(long m, int part) truncates millisecond date object
static int	getZoneMillis(java.util.Calendar cal, long millis)
static int	getZoneSeconds(java.util.Calendar cal)
static void	setTimeInMillis(java.util.Calendar cal, long millis) Sets the time in the given Calendar using the given milliseconds value; wrapper method to allow use of more efficient JDK1.4 method on JDK1.4 (was protected in earlier versions).
static TimestampData	toDate(java.lang.String string, java.lang.String pattern, java.text.SimpleDateFormat format)
static java.lang.String	toFormattedDate(java.util.Date date, java.lang.String pattern, java.text.SimpleDateFormat format)
static java.lang.String	toJavaDatePattern(java.lang.String format) Converts the given format into a pattern accepted by java.text.SimpleDataFormat
static int	toStandardIntervalPart(java.lang.String format)

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

tempCalDefault

public static final java.util.Calendar tempCalDefault

tempCalGMT

public static final java.util.Calendar tempCalGMT

Constructor Detail

HsqlDateTime

public HsqlDateTime()

Method Detail

getDateSeconds

public static long getDateSeconds(java.lang.String s)

getDateString

public static java.lang.String getDateString(long seconds)

getTimestampSeconds

public static long getTimestampSeconds(java.lang.String s)

getTimestampString

public static void getTimestampString(java.lang.StringBuffer sb,
                                      long seconds,
                                      int nanos,
                                      int scale)

getTimestampString

public static java.lang.String getTimestampString(long millis)

getCurrentDateMillis

public static long getCurrentDateMillis(long millis)

getSystemTimeString

public static java.lang.String getSystemTimeString()

convertMillisToCalendar

public static long convertMillisToCalendar(java.util.Calendar calendar,
                                           long millis)

convertMillisFromCalendar

public static long convertMillisFromCalendar(java.util.Calendar calendar,
                                             long millis)

setTimeInMillis

public static void setTimeInMillis(java.util.Calendar cal,
                                   long millis)

Sets the time in the given Calendar using the given milliseconds value; wrapper method to allow use of more efficient JDK1.4 method on JDK1.4 (was protected in earlier versions).

Parameters:

cal - the Calendar

millis - the time value in milliseconds

getTimeInMillis

public static long getTimeInMillis(java.util.Calendar cal)

Gets the time from the given Calendar as a milliseconds value; wrapper method to allow use of more efficient JDK1.4 method on JDK1.4 (was protected in earlier versions).

Parameters:

cal - the Calendar

Returns:

the time value in milliseconds

convertToNormalisedTime

public static long convertToNormalisedTime(long t)

convertToNormalisedTime

public static long convertToNormalisedTime(long t,
                                           java.util.Calendar cal)

convertToNormalisedDate

public static long convertToNormalisedDate(long t,
                                           java.util.Calendar cal)

getNormalisedTime

public static long getNormalisedTime(long t)

getNormalisedTime

public static long getNormalisedTime(java.util.Calendar cal,
                                     long t)

getNormalisedDate

public static long getNormalisedDate(long d)

getNormalisedDate

public static long getNormalisedDate(java.util.Calendar cal,
                                     long d)

getZoneSeconds

public static int getZoneSeconds(java.util.Calendar cal)

getZoneMillis

public static int getZoneMillis(java.util.Calendar cal,
                                long millis)

getDateTimePart

public static int getDateTimePart(long m,
                                  int part)

Returns the indicated part of the given millisecond date object.

Parameters:

m - the millisecond time value from which to extract the indicated part

part - an integer code corresponding to the desired date part

Returns:

the indicated part of the given java.util.Date object

getTruncatedPart

public static long getTruncatedPart(long m,
                                    int part)

truncates millisecond date object

getRoundedPart

public static long getRoundedPart(long m,
                                  int part)

rounded millisecond date object

toDate

public static TimestampData toDate(java.lang.String string,
                                   java.lang.String pattern,
                                   java.text.SimpleDateFormat format)

toFormattedDate

public static java.lang.String toFormattedDate(java.util.Date date,
                                               java.lang.String pattern,
                                               java.text.SimpleDateFormat format)

toJavaDatePattern

public static java.lang.String toJavaDatePattern(java.lang.String format)

Converts the given format into a pattern accepted by java.text.SimpleDataFormat

Parameters:

format -

toStandardIntervalPart

public static int toStandardIntervalPart(java.lang.String format)