FFn represents the fractional seconds where n indicates the number of digits in fractional part. Its default format is 'YYYY-MM-DD HH24:MI:SS.FF7'. The TIMESTAMP data type consists of date and time information. YYYY represents the year, MM represents the month, DD represents the day, HH24 represents hour, MI represents minute, and SS represents seconds. The default format for the SECONDDATE data type is 'YYYY-MM-DD HH24:MI:SS'. The SECONDDATE data type consists of year, month, day, hour, minute and second information to represent a date with time value. HH24 represents the hour from 0 to 24, MI represents the minute from 0 to 59, SS represents the second from 0 to 59. The default format for the TIME data type is 'HH24:MI:SS'. The TIME data type consists of hour, minute, and second to represent a time value. YYYY represents the year, MM represents the month, and DD represents the day. The default format for the DATE data type is 'YYYY-MM-DD'. The DATE data type consists of year, month, and day information to represent a date value. TINYINT, SMALLINT, INTEGER, BIGINT, SMALLDECIMAL, DECIMAL, REAL, DOUBLE In the SAP HANA Database each data type can be classified by its characteristic as follows: Table 2: Classification of data types Classification Mapping between SQL Data Type and Column Store Data Type.Supported Functions for Date/Time types.
The following table shows the built-in data types available in the SAP HANA Database. A special value of NULL is included in every data type to indicate the absence of a value. This section describes the data types used in the SAP HANA Database.ĭata type specifies the characteristics of a data value.
0 kommentar(er)
