SAPHANA学习（21）：SQL Function(U)

UCASE(<string>)

将字符串字符转换大写

UPPER(<string>)

SELECT UCASE ('Ant') FROM DUMMY;
SELECT UPPER ('Ant') FROM DUMMY;

UMINUS(<number>)

对应值取反

SELECT UMINUS(-765) FROM DUMMY;

UNICODE(<character>)

将字符转换为对应Unioncode

SELECT UNICODE ('A') FROM DUMMY;

UTCTOLOCAL (<time> [, <timezone> [, <timezone_dataset>]])

Converts the UTC(GMT) time <t> to the local time in a timezone.

SELECT UTCTOLOCAL(TO_TIMESTAMP('2012-01-01 01:00:00', 'YYYY-MM-DD HH24:MI:SS'), 'EST', 'sap') FROM DUMMY;