Could you tell me how to splice the two fields, I have a horizontal line joining together out of date, I need 20200106, for example, is my KEEPDATE date format, format for 2020/01/06, RSAID=KEEDATE type (date) + PLACEPOINTID field (number), need to spell out the effect of such as: 2020010614450
.

CodePudding user response:

The SELECT TO_CHAR (KEEDATE, 'yyyymmdd') | | PLACEPOINTID AS RSAID FROM TB