SAPHANA学习(21):SQL Function(U)

/*

144. UCASE

UCASE(<string>)

将字符串字符转换大写

UPPER(<string>)

*/

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

/*

145. UMINUS

UMINUS(<number>)

对应值取反

*/

SELECT UMINUS(-765) FROM DUMMY;

/*

146. UNICODE

UNICODE(<character>)

将字符转换为对应Unioncode

*/

SELECT UNICODE ('A') FROM DUMMY;

/*

147. UTCTOLOCAL

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;

 

上一篇:[LeetCode] 203. Remove Linked List Elements


下一篇:[E模拟] lc203. 移除链表元素(链表+模拟)