oracle.sql
Class DATE

java.lang.Object
  oracle.sql.Datum
      oracle.sql.DATE

All Implemented Interfaces:

java.io.Serializable

public class DATE
extends Datum

DATE Class

The DATE class provides conversions between the Oracle Date (ldx_t) data type and Java classes java.sql.Date, java.sql.Time, java.sql.Timestamp

The internal data for this object is stored as a seven byte array in the super class' storage area. The bytes are arranged as follows:

      Byte       Represents
       0         Century (19 for 1990)
       1         Decade  (90 for 1990)
       2         Month
       3         Day      
       4         Hour
       5         Minute
       6         Seconds
  

Static methods are used for conversions.

See Also:

Serialized Form

Field Summary

static int	BDA Bad day: above range
static int	BDAL Bad day: below range
static int	BDT Bad date format
static int	BHR Bad hour: above range
static int	BHRL Bad hour: below range
static int	BMN Bad minute: above range
static int	BMNL Bad minute: below range
static int	BMO Bad month: above range
static int	BMOL Bad month: below range
static int	BSC Bad second: above range
static int	BSCL Bad second: below range
static java.lang.String	BUILD_DATE
static int	BYR Bad year: above range
static int	BYRL Bad year: below range
static int	HRZER0 Zero valued hour
static int	MIZERO Zero valued minute
static int	MSD Day is one of those "missing" from the year 1582
static int	SEZERO Zero valued second
static boolean	TRACE
static int	YR0 Year zero does not exist

Constructor Summary

DATE()
Constructs a DATE object initialized to 1/1/1970.

DATE(byte[] date)
Create a DATE object represented by the given Oracle Date.

DATE(java.sql.Date date)
Create a DATE object given a Java Date object.

DATE(java.sql.Date date, java.util.Calendar cal)
Create a DATE object given a Java Date object and a Calendar

DATE(java.lang.Object obj)
Constructs a DATE object initialized to the value specified by the object

DATE(java.lang.Object obj, java.util.Calendar cal)
Constructs a DATE object initialized to the value specified by the object and a Calendar

DATE(java.lang.String str)
Create a DATE object given a Java String object.

DATE(java.lang.String str, boolean lenient)
Create a DATE object given a Java String object.

DATE(java.lang.String str, java.util.Calendar cal)
Create a DATE object given a Java String object and a Calendar

DATE(java.sql.Time time)
Create a DATE object given a Java Time object.

DATE(java.sql.Time time, java.util.Calendar cal)
Create a DATE object given a Java Time object and a Calendar

DATE(java.sql.Timestamp timestamp)
Create a DATE object given a Java Timestamp object

DATE(java.sql.Timestamp timestamp, java.util.Calendar cal)
Create a DATE object given a Java Timestamp object and a Calendar

Method Summary

DATE	addJulianDays(int julianDay, int julianSec) Add Julian days to a date.
DATE	addMonths(int months) Add months to a date.
static int	checkValidity(byte[] date) Checks the DATE passed in.
int	compareTo(DATE date) Returns -1 if DATE is less than date, 0 if DATE and date are equal (==), 1 if DATE is greater than date.
java.sql.Date	dateValue() Calls toDate to convert internal Oracle Date to a Java Date.
java.sql.Date	dateValue(java.util.Calendar cal) Calls toDate to convert internal Oracle Date and Calendar to a Java Date.
void	diffInJulianDays(DATE date, int[] julianDay, int[] julianSec) Calculates the difference between two dates in Julian days.
NUMBER	diffInMonths(DATE date) Calculates the difference between two dates in months.
static DATE	fromJulianDays(int julianDay, int julianSec) Convert given julian days and seconds to an Oracle Date.
static DATE	fromText(java.lang.String datestr, java.lang.String fmt, java.lang.String lang) Convert a string to a DATE object.
static DATE	getCurrentDate() Gets current date and time
boolean	isConvertibleTo(java.lang.Class cls) Determines if the object can be converted to a particular class
DATE	lastDayOfMonth() returns a DATE object intialized to the last day of the month .
java.lang.Object	makeJdbcArray(int arraySize) Returns a JDBC array representation of the datum
static void	numberToJulianDays(NUMBER num, int[] julianDay, int[] julianSec) Converts an Oracle Number to julian days and seconds
static byte[]	parseFormat(java.lang.String fmt, java.lang.String lang) Converts the fmt string into tokens for use by toText().
DATE	round(java.lang.String prec) returns a DATE object with date rounded to specified precision
DATE	setDayOfWeek(int day) returns a DATE object initialized to date advanced to the week of the day specified.
java.lang.String	stringValue() Calls toString to convert internal Oracle Date to a Java String.
java.sql.Timestamp	timestampValue() Calls toTimestamp to convert internal Oracle Date to a Java Timestamp.
java.sql.Timestamp	timestampValue(java.util.Calendar cal) Calls toTimestamp to convert internal Oracle Date and Calendar to a Java Timestamp.
java.sql.Time	timeValue() Calls toTime to convert internal Oracle Date to a Java Time.
java.sql.Time	timeValue(java.util.Calendar cal) Calls toTime to convert internal Oracle Date and Calendar to a Java Time.
byte[]	toBytes()
static byte[]	toBytes(java.sql.Date date) Convert Java Date to Oracle Date.
static byte[]	toBytes(java.sql.Date date, java.util.Calendar cal) Convert Java Date and Calendar to Oracle Date.
static byte[]	toBytes(java.lang.String str) Convert Java String to Oracle Date.
static byte[]	toBytes(java.lang.String str, java.util.Calendar cal) Convert Java String to Oracle Date.
static byte[]	toBytes(java.sql.Time time) Convert Java Time to Oracle Date.
static byte[]	toBytes(java.sql.Time time, java.util.Calendar cal) Convert Java Time and Calendar to Oracle Date.
static byte[]	toBytes(java.sql.Timestamp timestamp) Convert Java Timestamp to Oracle Date.
static byte[]	toBytes(java.sql.Timestamp timestamp, java.util.Calendar cal) Convert Java Timestamp and Calendar to Oracle Date.
static java.sql.Date	toDate(byte[] date) Convert Oracle Date to Java Date.
static java.sql.Date	toDate(byte[] date, java.util.Calendar cal) Convert Oracle Date and Calendar to Java Date.
java.lang.Object	toJdbc() Returns the JDBC representation of the datum object
void	toJulianDays(int[] julianDay, int[] julianSec) Convert to julian days and seconds from the given date.
NUMBER	toNumber() Converts date to an Oracle Number.
java.lang.String	toString()
static java.lang.String	toString(byte[] bytes) Converts a date to a string
java.lang.String	toText(byte[] pfmt, java.lang.String lang) Convert date to text as specified by fmt.
java.lang.String	toText(java.lang.String fmt, java.lang.String lang) Convert date to text as specified by fmt.
static java.sql.Time	toTime(byte[] date) Convert Oracle Date to Java Time.
static java.sql.Time	toTime(byte[] date, java.util.Calendar cal) Convert Oracle Date and Calendar to Java Time.
static java.sql.Timestamp	toTimestamp(byte[] date) Convert Oracle Date to Java Timestamp.
static java.sql.Timestamp	toTimestamp(byte[] date, java.util.Calendar cal) Convert Oracle Date and Calendar to Java Timestamp.
DATE	truncate(java.lang.String prec) returns a DATE object with date truncated to specified precision

Methods inherited from class oracle.sql.Datum

asciiStreamValue, bigDecimalValue, binaryStreamValue, booleanValue, byteValue, characterStreamValue, doubleValue, equals, floatValue, getBytes, getLength, getStream, intValue, longValue, setBytes, setShareBytes, shareBytes, stringValue

Methods inherited from class java.lang.Object

getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

BDA

public static final int BDA

Bad day: above range

See Also:

Constant Field Values

BDAL

public static final int BDAL

Bad day: below range

See Also:

Constant Field Values

BMO

public static final int BMO

Bad month: above range

See Also:

Constant Field Values

BMOL

public static final int BMOL

Bad month: below range

See Also:

Constant Field Values

BYR

public static final int BYR

Bad year: above range

See Also:

Constant Field Values

BYRL

public static final int BYRL

Bad year: below range

See Also:

Constant Field Values

BHR

public static final int BHR

Bad hour: above range

See Also:

Constant Field Values

BHRL

public static final int BHRL

Bad hour: below range

See Also:

Constant Field Values

BMN

public static final int BMN

Bad minute: above range

See Also:

Constant Field Values

BMNL

public static final int BMNL

Bad minute: below range

See Also:

Constant Field Values

BSC

public static final int BSC

Bad second: above range

See Also:

Constant Field Values

BSCL

public static final int BSCL

Bad second: below range

See Also:

Constant Field Values

MSD

public static final int MSD

Day is one of those "missing" from the year 1582

See Also:

Constant Field Values

YR0

public static final int YR0

Year zero does not exist

See Also:

Constant Field Values

BDT

public static final int BDT

Bad date format

See Also:

Constant Field Values

HRZER0

public static final int HRZER0

Zero valued hour

See Also:

Constant Field Values

MIZERO

public static final int MIZERO

Zero valued minute

See Also:

Constant Field Values

SEZERO

public static final int SEZERO

Zero valued second

See Also:

Constant Field Values

BUILD_DATE

public static final java.lang.String BUILD_DATE

See Also:

Constant Field Values

TRACE

public static final boolean TRACE

See Also:

Constant Field Values

Constructor Detail

DATE

public DATE()

Constructs a DATE object initialized to 1/1/1970.

DATE

public DATE(byte[] date)

Create a DATE object represented by the given Oracle Date.

Parameters:

date - Oracle Date

DATE

public DATE(java.sql.Date date)

Create a DATE object given a Java Date object.

Parameters:

date - Java Date object

DATE

public DATE(java.sql.Time time)

Create a DATE object given a Java Time object.

Parameters:

time - Java Time object

DATE

public DATE(java.sql.Timestamp timestamp)

Create a DATE object given a Java Timestamp object

Parameters:

timestamp - Java Timestamp object

DATE

public DATE(java.sql.Date date,
            java.util.Calendar cal)

Create a DATE object given a Java Date object and a Calendar

Parameters:

date - Java Date object

cal - Java Calendar object which encapsulates the timezone information of date

DATE

public DATE(java.sql.Time time,
            java.util.Calendar cal)

Create a DATE object given a Java Time object and a Calendar

Parameters:

time - Java Time object

cal - Java Calendar object which encapsulates the timezone information of time

DATE

public DATE(java.sql.Timestamp timestamp,
            java.util.Calendar cal)

Create a DATE object given a Java Timestamp object and a Calendar

Parameters:

timestamp - Java Timestamp object

cal - Java Calendar object which encapsulates the timezone information of timestamp

DATE

public DATE(java.lang.String str)

Create a DATE object given a Java String object.

Parameters:

str - Java String object

DATE

public DATE(java.lang.String str,
            boolean lenient)
     throws java.text.ParseException

Create a DATE object given a Java String object.

Parameters:

str - Java String object

lenient - Java Boolean variable

Throws:

java.text.ParseException

DATE

public DATE(java.lang.String str,
            java.util.Calendar cal)

Create a DATE object given a Java String object and a Calendar

Parameters:

str - Java String object

cal - Java Calendar object which encapsulates the timezone information for interpreting str

DATE

public DATE(java.lang.Object obj)
     throws java.sql.SQLException

Constructs a DATE object initialized to the value specified by the object

Parameters:

obj - Object value

obj - Object value

obj - Object value

Throws:

java.sql.SQLException - if initialization is not allowed

DATE

public DATE(java.lang.Object obj,
            java.util.Calendar cal)
     throws java.sql.SQLException

Constructs a DATE object initialized to the value specified by the object and a Calendar

Parameters:

obj - Object value

cal - Calendar to use

obj - Object value

obj - Object value

cal - Calendar which encapsulates the timezone information of obj

Throws:

java.sql.SQLException - if initialization is not allowed

Method Detail

toDate

public static java.sql.Date toDate(byte[] date)

Convert Oracle Date to Java Date.

Parameters:

date - Oracle Date to be converted

Returns:

the java.sql.Date object represented by the Oracle Date date.

toTime

public static java.sql.Time toTime(byte[] date)

Convert Oracle Date to Java Time.

Parameters:

date - Oracle Date to be converted

Returns:

the java.sql.Time object represented by the Oracle Date date.

toTimestamp

public static java.sql.Timestamp toTimestamp(byte[] date)

Convert Oracle Date to Java Timestamp.

Parameters:

date - Oracle Date to be converted

Returns:

the java.sql.Timestamp object represented by the Oracle Date date.

toDate

public static java.sql.Date toDate(byte[] date,
                                   java.util.Calendar cal)

Convert Oracle Date and Calendar to Java Date.

Parameters:

date - Oracle Date to be converted

cal - Calendar which encapsulates the timezone information to be used to create Date object

Returns:

the java.sql.Date object represented by the Oracle Date date.

toTime

public static java.sql.Time toTime(byte[] date,
                                   java.util.Calendar cal)

Convert Oracle Date and Calendar to Java Time.

Parameters:

date - Oracle Date to be converted

cal - Calendar which encapsulates the timezone information to be used to create the Time object

Returns:

the java.sql.Time object represented by the Oracle Date date.

toTimestamp

public static java.sql.Timestamp toTimestamp(byte[] date,
                                             java.util.Calendar cal)

Convert Oracle Date and Calendar to Java Timestamp.

Parameters:

date - Oracle Date to be converted

cal - Calendar which encapsulates the timezone information to be used to create the Timestamp object

Returns:

the java.sql.Timestamp object represented by the Oracle Date date.

toString

public static java.lang.String toString(byte[] bytes)

Converts a date to a string

Parameters:

date - a byte array

Returns:

String representing the date

toBytes

public byte[] toBytes()

toBytes

public static byte[] toBytes(java.sql.Date date)

Convert Java Date to Oracle Date.

Parameters:

date - java.sql.Date object to be converted.

Returns:

the byte array representing the input date.

toBytes

public static byte[] toBytes(java.sql.Time time)

Convert Java Time to Oracle Date.

Parameters:

time - java.sql.Time object to be converted.

Returns:

the byte array representing the input time.

toBytes

public static byte[] toBytes(java.sql.Timestamp timestamp)

Convert Java Timestamp to Oracle Date.

Parameters:

timestamp - java.sql.Timestamp object to be converted.

Returns:

the byte array representing the input timestamp.

toBytes

public static byte[] toBytes(java.sql.Date date,
                             java.util.Calendar cal)

Convert Java Date and Calendar to Oracle Date.

Parameters:

date - java.sql.Date object to be converted.

cal - java.util.Calendar object which encapsulates the timezone information of date

Returns:

the byte array representing the input date.

toBytes

public static byte[] toBytes(java.sql.Time time,
                             java.util.Calendar cal)

Convert Java Time and Calendar to Oracle Date.

Parameters:

time - java.sql.Time object to be converted.

cal - java.util.Calendar object which encapsulates the timezone information of time

Returns:

the byte array representing the input time.

toBytes

public static byte[] toBytes(java.sql.Timestamp timestamp,
                             java.util.Calendar cal)

Convert Java Timestamp and Calendar to Oracle Date.

Parameters:

timestamp - java.sql.Timestamp object to be converted.

cal - java.util.Calendar object which encapsulates the timezone information of date

Returns:

the byte array representing the input timestamp.

toBytes

public static byte[] toBytes(java.lang.String str)

Convert Java String to Oracle Date.

Parameters:

str - java.lang.String object to be converted.

Returns:

the byte array representing the input string.

toBytes

public static byte[] toBytes(java.lang.String str,
                             java.util.Calendar cal)

Convert Java String to Oracle Date.

Parameters:

str - java.lang.String object to be converted.

cal - java.util.Calendar object which encapsulates the timezone information for interpreting str

Returns:

the byte array representing the input string.

dateValue

public java.sql.Date dateValue()

Calls toDate to convert internal Oracle Date to a Java Date.

Overrides:

dateValue in class Datum

Returns:

a Java Date value

timeValue

public java.sql.Time timeValue()

Calls toTime to convert internal Oracle Date to a Java Time.

Overrides:

timeValue in class Datum

Returns:

a Java Time value

timestampValue

public java.sql.Timestamp timestampValue()

Calls toTimestamp to convert internal Oracle Date to a Java Timestamp.

Overrides:

timestampValue in class Datum

Returns:

a Java Timestamp value

dateValue

public java.sql.Date dateValue(java.util.Calendar cal)

Calls toDate to convert internal Oracle Date and Calendar to a Java Date.

Parameters:

cal - Calendar to use

Returns:

a Java Date value

timeValue

public java.sql.Time timeValue(java.util.Calendar cal)

Calls toTime to convert internal Oracle Date and Calendar to a Java Time.

Overrides:

timeValue in class Datum

Parameters:

cal - Calendar to use

Returns:

a Java Time value

timestampValue

public java.sql.Timestamp timestampValue(java.util.Calendar cal)

Calls toTimestamp to convert internal Oracle Date and Calendar to a Java Timestamp.

Overrides:

timestampValue in class Datum

Parameters:

cal - Calendar to use

Returns:

a Java Timestamp value

stringValue

public java.lang.String stringValue()

Calls toString to convert internal Oracle Date to a Java String.

Overrides:

stringValue in class Datum

Returns:

a Java String value

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object

toJdbc

public java.lang.Object toJdbc()

Returns the JDBC representation of the datum object

Specified by:

toJdbc in class Datum

Returns:

an object containing the JDBC value

makeJdbcArray

public java.lang.Object makeJdbcArray(int arraySize)

Returns a JDBC array representation of the datum

Specified by:

makeJdbcArray in class Datum

Parameters:

arraySize - size of the array

Returns:

an object containing the JDBC array value

isConvertibleTo

public boolean isConvertibleTo(java.lang.Class cls)

Determines if the object can be converted to a particular class

Specified by:

isConvertibleTo in class Datum

Parameters:

cls - Class to convert to

Returns:

true, if conversion to cls is permitted false, if conversion to cls is not permitted

addJulianDays

public DATE addJulianDays(int julianDay,
                          int julianSec)
                   throws java.sql.SQLException

Add Julian days to a date.

Parameters:

julianDay - Number of Julian days to add to DATE

julianSec - Number of seconds past midnight

Returns:

new DATE object initalized to the DATE values added to the Julian days.

Throws:

java.sql.SQLException - if Java implementation is not available

addMonths

public DATE addMonths(int months)
               throws java.sql.SQLException

Add months to a date.

Parameters:

months - integral months to add to date

Returns:

new DATE object initialized to the DATE value added to months. months can be negative to perform month subtraction.

Throws:

java.sql.SQLException - if Java implementation is not available

diffInJulianDays

public void diffInJulianDays(DATE date,
                             int[] julianDay,
                             int[] julianSec)
                      throws java.sql.SQLException

Calculates the difference between two dates in Julian days.

Parameters:

date - Date to be subtracted.

julianDay - Number of Julian days

julianSec - Number of seconds past midnight

Throws:

java.sql.SQLException - if Java implementation is not available

diffInMonths

public NUMBER diffInMonths(DATE date)
                    throws java.sql.SQLException

Calculates the difference between two dates in months.

Parameters:

date - Date to be subtracted.

Returns:

NUMBER difference in months as an Oracle Number.

Throws:

java.sql.SQLException - if Java implementation is not available

getCurrentDate

public static DATE getCurrentDate()
                           throws java.sql.SQLException

Gets current date and time

Returns:

DATE object

Throws:

java.sql.SQLException - if Java implementation is not available

checkValidity

public static int checkValidity(byte[] date)
                         throws java.sql.SQLException

Checks the DATE passed in.

Parameters:

date - Date to be checked

Returns:

0 if the date is valid or the ORed representations in the following table:

BDA	Bad day: above range
BDAL	Bad day: below range
BMO	Bad month: above range
BMOL	Bad month: below range
BYR	Bad year: above range
BYRL	Bad year: below range
BHR	Bad hour: above range
BHRL	Bad hour: below range
BMN	Bad minute: above range
BMNL	Bad minute: below range
BSC	Bad second: above range
BSCL	Bad second: below range
MSD	Day is one of those "missing" from the year 1582
YR0	Year zero does not exist
BDT	Bad date format
HRZERO	Zero valued hour
MIZERO	Zero valued minute
SEZERO	Zero valued second

Throws:

java.sql.SQLException - if Java implementation is not available

fromJulianDays

public static DATE fromJulianDays(int julianDay,
                                  int julianSec)
                           throws java.sql.SQLException

Convert given julian days and seconds to an Oracle Date.

Parameters:

julianDay - Number of Julian days

julianSec - Number of seconds past midnight

Returns:

new DATE object initialized based on the number of Julian days.

Throws:

java.sql.SQLException - if Java implementation is not available

fromText

public static DATE fromText(java.lang.String datestr,
                            java.lang.String fmt,
                            java.lang.String lang)
                     throws java.sql.SQLException

Convert a string to a DATE object.

Parameters:

datestr - Input Date string

fmt - Date Format

lang - Input date language

Returns:

DATE object Note: Some of the extended Date Formats supported by the C Date libraries from CORE are not supported in this pure Java equivalent implementation. The Format strings supported are:

String	Meaning
a.d.	B.C./A.D. indicator
a.m.	A.M./P.M. indicator
ad	BC/AD indicator
am	AM/PM indicator
b.c.	B.C./A.D. indicator
bc	BC/AD indicator
d	day of the week
day	name of the day, spelled out
dd	day of the month
ddd	day of year
dy	name of weekday abbreviated
hh	hour representation in 12 hour format
hh24	hour representation in 24 hour format
mi	minutes
mm	two digit month representation
mon	month abbreviation
month	name of the month, spelled out
p.m.	A.M./P.M. indicator
pm	AM/PM indicator
ss	two digit second representation
Y	last digit of the year
YY	last two digits of a year
YYY	last three digits of a year
YYYY	year
""	all text in quotes is copied into the output string It is not possible to place a quote character into the output string. On input, literal text is a placeholder for another string of the same length
/,%&@#..	punctuation (non-alphanumeric characters) is treated exactly like a literal without the need for quotes.

The Date format string not supported versus the C library are:

String	Meaning
E	abbreviated era name
EE	full era name
FX	all date literals must be an exact match
j	Julian day
RM	Roman numeral month (I-XII)
RR	Round year with two digits (on input, rounds the century up one if the year is <50 and the reference date is >= 50, and down one century if the year is >= 50 and the reference date is <50)
RRRR	Round year (on input, accepts either four digit input or, for two digit input, rounds the century up one if the year is <50 and the reference date is >= 50, and down one century if the year is >= 50 and the reference date is <50)
sssss	number of seconds past midnight
sy,yyy	signed year (BC dates have "-" in front)
syYYY	signed year (BC dates have "-" in front)
Y,YYY	year with comma
YEAR	year number spelled out

Also parsing is strict i.e. spaces and literals should match the format string exactly. (except for a.d./b.c. the string should be ad/bc)

Throws:

java.sql.SQLException

lastDayOfMonth

public DATE lastDayOfMonth()
                    throws java.sql.SQLException

returns a DATE object intialized to the last day of the month .

Returns:

a DATE object

Throws:

java.sql.SQLException - if Java implementation is not available

numberToJulianDays

public static void numberToJulianDays(NUMBER num,
                                      int[] julianDay,
                                      int[] julianSec)
                               throws java.sql.SQLException

Converts an Oracle Number to julian days and seconds

Parameters:

num - Oracle Number to convert

julianDay - Number of Julian days

julianSec - Number of seconds past midnight

Throws:

java.sql.SQLException - if Java implementation is not available

round

public DATE round(java.lang.String prec)
           throws java.sql.SQLException

returns a DATE object with date rounded to specified precision

Parameters:

prec - precision to use while rounding

Returns:

DATE object

Throws:

java.sql.SQLException - if Java implementation is not available

setDayOfWeek

public DATE setDayOfWeek(int day)
                  throws java.sql.SQLException

returns a DATE object initialized to date advanced to the week of the day specified.

Parameters:

day - day of the week the date needs to be advanced

Returns:

DATE object.

Throws:

java.sql.SQLException - if Java implementation is not available

toJulianDays

public void toJulianDays(int[] julianDay,
                         int[] julianSec)
                  throws java.sql.SQLException

Convert to julian days and seconds from the given date.

Parameters:

julianDay - Number of Julian days

julianSec - Number of seconds past midnight

Throws:

java.sql.SQLException - if Java implementation is not available

toNumber

public NUMBER toNumber()
                throws java.sql.SQLException

Converts date to an Oracle Number.

Returns:

an Oracle Number

Throws:

java.sql.SQLException - if Java implementation is not available

toText

public java.lang.String toText(java.lang.String fmt,
                               java.lang.String lang)
                        throws java.sql.SQLException

Convert date to text as specified by fmt.

Parameters:

fmt - date format

lang - the NLS language the conversion is to be performed in, null indicates use default.

Returns:

a String converted from date via format fmt.

Throws:

java.sql.SQLException - if Java implementation is not available or an invalid format string is provided.

toText

public java.lang.String toText(byte[] pfmt,
                               java.lang.String lang)
                        throws java.sql.SQLException

Convert date to text as specified by fmt.

Parameters:

pfmt - date format parsed by parseFormat

lang - the NLS language the conversion is to be performed in, null indicates use default.

Returns:

a String converted from date via format fmt.

Throws:

java.sql.SQLException - if Java implementation is not available or an invalid format string is provided.

parseFormat

public static byte[] parseFormat(java.lang.String fmt,
                                 java.lang.String lang)
                          throws java.sql.SQLException

Converts the fmt string into tokens for use by toText().

Parameters:

fmt - date format

lang - A String containing NLS Language and/or Territory null indicates to use default.

Returns:

a byte array containing tokens from the parsed format

Throws:

java.sql.SQLException - if the format string can not be parsed.

truncate

public DATE truncate(java.lang.String prec)
              throws java.sql.SQLException

returns a DATE object with date truncated to specified precision

Parameters:

prec - precision to use while truncating

Returns:

DATE object

Throws:

java.sql.SQLException - if Java implementation is not available

compareTo

public int compareTo(DATE date)

Returns -1 if DATE is less than date, 0 if DATE and date are equal (==), 1 if DATE is greater than date.

Parameters:

date - input Oracle Date

Returns:

integer result of comparison