Data type conversions (casting) in expressions and property assignments

To type

DateTime

Date

Time of Day

Integer

Decimal

Double

True or
False

Other (Text, Identifier)

From type

DateTime

D

D

V

V

V

  C

Date

V, 2

V, 5

V, 5

V, 5

  C

Time of Day

VN 3

V, 4

V, 4

  C

Integer

V, 1

V, 5

V, 3

V

V

  C

Decimal

V, 1

V, 5

V, 4

N

V

  C

Double

V, 1

V, 5

V, 4

N

V

  C

True or False

  C

Other

S

S

S

S

S

S

S

Entry

Description

No conversion necessary

Conversion is not permitted.

C

Copies the value without examining whether it is valid.

S

Copies the value with no changes, then tests the result. If the value is not suitable for the target type, marks the property with the External attribute. The External attribute indicates that the value is in the form entered by the user and is not suitable for the type of the property; its use is likely to result in an error. OLSOK 1/19/07

You can test this attribute through these three Public API methods in the ClipboardProperty interface:

• hasGoodValue() — Returns true if the property is not empty and does not have the Error attribute or External attribute set, false otherwise.
• hasInvalidValue() — Returns true if the property is not empty and has the External attribute set, or false otherwise.
• hasValidValue() — Returns true if the property is not empty and does not have the External attribute set, false otherwise.

D

Date narrowing conversion, the appropriate subfield is selected and used

Results of this conversion are correct only for the London time zone. See Understanding the Date, Time, and DateTime property types for an alternative approach that is often preferable.

N

Numeric narrowing conversion, the fractional portion is rounded.

V

Uses a preferred numeric conversion (double, BigDecimal) as defined for the respective data types above

1

Conversion of a numeric type to DateTime treats the value as a DateTime in the GMT time zone and appends GMT.

2

Conversion of Date to DateTime appends a time of 00:00:00.000 and a time zone of GMT.

3

Integer to Time of Day considers the Integer value to be a number of seconds since midnight. Time of Day to Integer sets the integer value to the number of seconds since midnight.

4

Decimal and Double to Time of Day considers the fractional component to be a fraction of a day and ignores the integer component (to the left of the decimal point). Time of Day to Decimal and Double set the fractional component of a day.

5

Numeric types converted to Date treat the (rounded) value as the number of days from the Java epoch (January 1, 1970). Date types converted to numeric types supplies the number of days (plus or minus) from the Java epoch.

For example, the integer value 0 is converted into the Date value 19700101.

When converting a number to True or False, zero is converted to false, and any value other than zero is true. B-13127