Question

list the datatypes available in
1.numeric datatype
2.alphaumeric datatype
3.data datatype
4.binary datatype
5.date time

wrong answer will be reported!!

answer it as soon as possible!!

Answer 1

1)..In this Topic:

Data Types for Fixed-point Numbers. NUMBER. DECIMAL , NUMERIC. INT , INTEGER , BIGINT , SMALLINT , TINYINT, BYTEINT. ...

Data Types for Floating Point Numbers. FLOAT , FLOAT4 , FLOAT8. DOUBLE , DOUBLE PRECISION , REAL. Floating Point Examples in Table Columns.

Numeric Constants.



2))PointBase supports the following data types for its column and parameter declarations.

CHARACTER [(length)] or CHAR [(length)]

VARCHAR (length)

BOOLEAN.

SMALLINT.

INTEGER or INT.

DECIMAL [(p[,s])] or DEC [(p[,s])]

NUMERIC [(p[,s])]

REAL.


PointBase supports the following data types for its column and parameter declarations.

CHARACTER [(length)] or CHAR [(length)]

VARCHAR (length)

BOOLEAN.

SMALLINT.

INTEGER or INT.

DECIMAL [(p[,s])] or DEC [(p[,s])]

NUMERIC [(p[,s])]

REAL.


4))Arbitrary-precision or bignum.

Complex.

Decimal.

Fixed point.

Floating point. Double precision. Extended precision. Long double. Octuple precision. Quadruple precision. Singleprecision. Reduced precision. Minifloat. Half precision. bfloat16.

Integer. signedness.

Interval.

Rational.



5))Date and Time data types

Data typeFormatStorage size (bytes)dateYYYY-MM-DD3smalldatetimeYYYY-MM-DD hh:mm:ss4datetimeYYYY-MM-DD hh:mm:ss[.nnn]8datetime2YYYY-MM-DD hh:mm:ss[.nnnnnnn]6 to 8




Hope it helps u


Thnx
3))