cancel
Showing results for 
Search instead for 
Did you mean: 

Sap Hana webide

0 Kudos
93

Hello guys,

I have a very basic question regarding sap hana time dimension tables.

We have m_time_dimension table right. I just want to know what is the exact difference between DATE_SQL and DATE_SAP in it.

Thanks

HakanHaslaman
Product and Topic Expert
Product and Topic Expert

Accepted Solutions (1)

Accepted Solutions (1)

pfefferf
Active Contributor

DATE_SQL contains date in the native SQL Date type format.

DATE_SAP is of type VARCHAR with lenght 8 to represent the date in format YYYYMMDD. This is the format like dates are handled in a SAP ABAP system.

Answers (0)