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

1 Posts

1 Users

0 Reactions

1,247 Views

RSS

Posts: 488

admin

Admin

Topic starter

Aug 17, 2022 10:39 pm

(@admin)

Knight3

Joined: 3 years ago

select replace(to_varchar(123456789,'9,999'),',','.') as "DotSeperator" from dummy;

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.

Topic Tags

sap hana thousand seperator format

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed