Forums
Các công cụ tùy biế...
SAP HANA
Cách thay đổi dấu p...
 
Notifications
Clear all

Cách thay đổi dấu phân cách hàng ngàn từ dấu phẩy sang dấu chấm trong SAP HANA

 
SAP HANA
Last Post by admin 2 years ago
1 Posts
1 Users
0 Likes
794 Views
RSS
admin
Posts: 337
 admin
Admin
Topic starter
Aug 17, 2022 10:39 pm
(@admin)
Prominent Member
Joined: 3 years ago
select replace(to_varchar(123456789,'9,999'),',','.') as "DotSeperator" from dummy;

Link tham khảo

  REPLACE(originalString, searchString, replaceString))

Searches in for all occurrences of and replaces them with.

  • If two overlapping substrings match the in the , then only the first occurrence is replaced.

  • If does not contain an occurrence of , then is returned unchanged.

  • If , , or are NULL, then NULL is returned.

Website | LinkedIn | YouTube | Facebook | SAP Community
www.smartis.com.vn | www.cloud.smartis.com.vn | www.learning.smartis.com.vn

Reply
Topic Tags
sap hana thousand seperator format
Forum Jump:
  Previous Topic
Next Topic  
Related Topics
Topic Tags:  sap hana (36) , thousand seperator (1) , format (2) ,
Share:
x Powerful Protection for WordPress, from Shield Security
This Site Is Protected By
Shield Security →