Sybase 7.5 Time data types, Other data types, Selecting from the Data Type dropdown listbox, 127

Models: 7.5

1 288
Download 288 pages 28.98 Kb
Page 137
Image 137

Chapter 2 Building an Object-Oriented Model

Time data types

Conceptual data type

What it stores

Date

Day, month, year

 

 

Time

Hour, minute, and second

 

 

Date & Time

Date and time

 

 

Timestamp

System date and time

 

 

Other data types

Conceptual data type

Binary

Long Binary

Image

Bitmap

OLE

Other

Undefined

What it stores

Binary strings

Binary strings

Images

Images in bitmap format (BMP)

OLE links

User-defined data type

Not yet defined data type

Length?

Maximum

Maximum

Maximum

Maximum

Maximum

ϖTo select a data type from a list of standard data types:

1Select ModelDomains. The List of Domains appears.

2Click the domain to define.

An arrow appears at the beginning of the line.

3Click the Properties tool. or

Double-click the arrow at the beginning of the line. The domain property sheet appears.

4Click the Question Mark button next to the Data Type dropdown listbox.

Selecting from the Data Type dropdown listbox

You can also select a data type directly from the Data Type dropdown listbox.

127

Page 137
Image 137
Sybase 7.5 manual Time data types, Other data types, To select a data type from a list of standard data types, 127