Date Format and Number Format

[#1]

Hello,

Is there any possibility to change the date or number in HANA? Is it possible for a user to see amounts in the data preview as e.g. 12.000,50 vs. 12,000.50 ?

What about a similar question concerning the date format?

Thanks,

Ingo

[lbreddemann · Accepted solution]

Hi Ingo

the date/number format completely depends on the client you are using to display the data.

In SAP HANA studio, you can switch on/off output formatting :

However, this will use the local locale formatting preferences.

For more control on the formatting a proper reporting tool is required.

- Lars