org.sourceforge.jxdbcon.postgresql
Class PGTextTypes

java.lang.Object
  |
  +--org.sourceforge.jxdbcon.postgresql.PGTextTypes

public class PGTextTypes

extends Object

The text types used in the PostgreSQL database system.

Version:

$Revision: 1.5 $

Author:

Keve Müller, Peter Brant

Nested Class Summary

static class	PGTextTypes.PGbpchar CHAR() type.
static class	PGTextTypes.PGchar CHAR(1) type.
static class	PGTextTypes.PGname VARCHAR(32) type.
static class	PGTextTypes.PGtext LONGVARCHAR type.
static class	PGTextTypes.PGvarchar VARCHAR() type.

Constructor Summary

PGTextTypes()

Method Summary

static Date	getPGDate(String val) Get the string value as a Date.
static Time	getPGTime(String val) Get the value as a Time.
static Timestamp	getPGTimestamp(String val) Get the value as a Timestamp.

Methods inherited from class java.lang.Object

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

Constructor Detail

PGTextTypes

public PGTextTypes()

Method Detail

getPGDate

public static final Date getPGDate(String val)
                            throws SQLException

Get the string value as a Date. Accepts Date or Timestamp strings. Needs to be overridden, because PG (sometimes) appends the time zone offset to the timestamp string.

SQLException

getPGTime

public static final Time getPGTime(String val)
                            throws SQLException

Get the value as a Time. Accepts Time or Timestamp strings. Needs to be overridden, because PG (sometimes) appends the time zone offset to the timestamp string.

SQLException

getPGTimestamp

public static final Timestamp getPGTimestamp(String val)
                                      throws SQLException

Get the value as a Timestamp. Allowed input is the string representation of a Date, Time or Timestamp value. hh:mm:ss or yyyy-mm-dd or yyyy-mm-dd hh:mm:ss.ffffff

SQLException