Top Description Inners Fields Constructors Methods
org.hsqldb.types

public Class HsqlDateTime

extends Object
Class Inheritance
Imports
org.hsqldb.error.Error, .ErrorCode, org.hsqldb.lib.IntValueHashMap, .StringUtil, java.text.SimpleDateFormat, java.util.Calendar, .Date, .GregorianCalendar, .Locale, .TimeZone
collection of static methods to convert Date and Timestamp strings into corresponding Java objects and perform other Calendar related operation.

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.

Author
Fred Toussi (fredt@users dot sourceforge.net)
Since
1.7.0
Version
2.7.3

Nested and Inner Type Summary

Modifier and TypeClass and Description
public static class
HsqlDateTime.SystemTimeString

Timestamp String generator

Field Summary

Modifier and TypeField and Description
public static final Locale
defaultLocale

private static final SimpleDateFormat
sdfd

private static final String
sdfdPattern

private static final SimpleDateFormat
sdfts

private static final String
sdftsPattern

private static final String
sdftsSysPattern

private static final IntValueHashMap<String>
shortNameToIntervalTypeCode

private static final Date
sysDate

private static final Calendar
tempCalDefault

private static final Calendar
tempCalGMT

Constructor Summary

AccessConstructor and Description
public
HsqlDateTime()

Method Summary

Modifier and TypeMethod and Description
public static long
convertMillisFromCalendar(Calendar sourceCalendar, Calendar targetClendar, long millis)

public static long
convertMillisToCalendar(Calendar calendar, long millis)

public static long
convertSecondsFromCalendar(Calendar sourceCalendar, Calendar targetClendar, long seconds)

public static long
getDateSeconds(String s)

public static String
getDateString(long seconds)

public static long
getNormalisedDate(long d)

public static long
getNormalisedDate(Calendar calendar, long t)

public static long
getNormalisedTime(long t)

public static long
getNormalisedTime(Calendar calendar, long t)

public static long
getRoundedPart(Calendar calendar, long m, int part)

rounded millisecond date object

public static long
getTimestampSeconds(String s)

public static String
getTimestampString(long seconds, int nanos, int scale)

public static String
getTimestampString(long millis)

public static long
getTruncatedPart(Calendar calendar, long m, int part)

truncates millisecond date object

public static int
getZoneSeconds()

public static int
getZoneSeconds(Calendar calendar)

private static void
resetToDate(Calendar cal)

private static void
resetToTime(Calendar cal)

public static int
toStandardIntervalPart(String id)

public static void
zeroFromPart(Calendar cal, int part)

Inherited from java.lang.Object:
cloneequalsfinalizegetClasshashCodenotifynotifyAlltoStringwaitwaitwait

Field Detail

defaultLocaleback to summary
public static final Locale defaultLocale
sdfdback to summary
private static final SimpleDateFormat sdfd
sdfdPatternback to summary
private static final String sdfdPattern
sdftsback to summary
private static final SimpleDateFormat sdfts
sdftsPatternback to summary
private static final String sdftsPattern
sdftsSysPatternback to summary
private static final String sdftsSysPattern
shortNameToIntervalTypeCodeback to summary
private static final IntValueHashMap<String> shortNameToIntervalTypeCode
sysDateback to summary
private static final Date sysDate
tempCalDefaultback to summary
private static final Calendar tempCalDefault
tempCalGMTback to summary
private static final Calendar tempCalGMT

Constructor Detail

HsqlDateTimeback to summary
public HsqlDateTime()

Method Detail

convertMillisFromCalendarback to summary
public static long convertMillisFromCalendar(Calendar sourceCalendar, Calendar targetClendar, long millis)
convertMillisToCalendarback to summary
public static long convertMillisToCalendar(Calendar calendar, long millis)
convertSecondsFromCalendarback to summary
public static long convertSecondsFromCalendar(Calendar sourceCalendar, Calendar targetClendar, long seconds)
getDateSecondsback to summary
public static long getDateSeconds(String s)
getDateStringback to summary
public static String getDateString(long seconds)
getNormalisedDateback to summary
public static long getNormalisedDate(long d)
getNormalisedDateback to summary
public static long getNormalisedDate(Calendar calendar, long t)
getNormalisedTimeback to summary
public static long getNormalisedTime(long t)
getNormalisedTimeback to summary
public static long getNormalisedTime(Calendar calendar, long t)
getRoundedPartback to summary
public static long getRoundedPart(Calendar calendar, long m, int part)

rounded millisecond date object

getTimestampSecondsback to summary
public static long getTimestampSeconds(String s)
getTimestampStringback to summary
public static String getTimestampString(long seconds, int nanos, int scale)
getTimestampStringback to summary
public static String getTimestampString(long millis)
getTruncatedPartback to summary
public static long getTruncatedPart(Calendar calendar, long m, int part)

truncates millisecond date object

getZoneSecondsback to summary
public static int getZoneSeconds()
getZoneSecondsback to summary
public static int getZoneSeconds(Calendar calendar)
resetToDateback to summary
private static void resetToDate(Calendar cal)
resetToTimeback to summary
private static void resetToTime(Calendar cal)
toStandardIntervalPartback to summary
public static int toStandardIntervalPart(String id)
zeroFromPartback to summary
public static void zeroFromPart(Calendar cal, int part)
org.hsqldb.types back to summary

public Class HsqlDateTime.SystemTimeString

extends Object
Class Inheritance
Timestamp String generator

Field Summary

Modifier and TypeField and Description
private Date
date

private SimpleDateFormat
dateFormat

Constructor Summary

AccessConstructor and Description
public
SystemTimeString()

Method Summary

Modifier and TypeMethod and Description
public synchronized String
getTimestampString()

Inherited from java.lang.Object:
cloneequalsfinalizegetClasshashCodenotifynotifyAlltoStringwaitwaitwait

Field Detail

dateback to summary
private Date date
dateFormatback to summary
private SimpleDateFormat dateFormat

Constructor Detail

SystemTimeStringback to summary
public SystemTimeString()

Method Detail

getTimestampStringback to summary
public synchronized String getTimestampString()