Data type default values support `DATE_FORMAT(NOW(),'%Y-%m...')` #51031

zimulala · 2024-02-07T04:15:18Z

to_char(sysdate, 'yyyymm') -> DATE_FORMAT(NOW(),'%Y-%m')
to_char(sysdate,'yyyymmdd') -> DATE_FORMAT(NOW(),'%Y-%m-%d')
to_char(sysdate,'yyyy-mm-dd-hh24.mi.ss') -> DATE_FORMAT(NOW(),'%Y-%m-%d %H.%i.%s')
to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') -> DATE_FORMAT(NOW(),'%Y-%m-%d %H:%i:%s')
trunc(sysdate,'mm') -> DATE_FORMAT(NOW(),'%Y-%m-%d')

…%m...')` (#51076) close #51031

zimulala mentioned this issue Feb 7, 2024

Data type default values support some expressions #50936

Closed

13 tasks

zimulala changed the title ~~Data type default values support~~ Data type default values support DATE_FORMAT(NOW(),'%Y-%m...') Feb 7, 2024

zimulala self-assigned this Feb 7, 2024

zimulala added type/new-feature feature/accepted This feature request is accepted by product managers labels Feb 7, 2024

zimulala mentioned this issue Feb 8, 2024

parser, ddl: data type default values support DATE_FORMAT(NOW(),'%Y-%m...') #51076

Merged

13 tasks

ti-chi-bot bot closed this as completed in #51076 Feb 26, 2024

ti-chi-bot bot pushed a commit that referenced this issue Feb 26, 2024

parser, ddl: data type default values support `DATE_FORMAT(NOW(),'%Y-…

b9e98ab

…%m...')` (#51076) close #51031

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Data type default values support `DATE_FORMAT(NOW(),'%Y-%m...')` #51031

Data type default values support `DATE_FORMAT(NOW(),'%Y-%m...')` #51031

zimulala commented Feb 7, 2024 •

edited

Loading

Data type default values support DATE_FORMAT(NOW(),'%Y-%m...') #51031

Data type default values support DATE_FORMAT(NOW(),'%Y-%m...') #51031

Comments

zimulala commented Feb 7, 2024 • edited Loading

Data type default values support `DATE_FORMAT(NOW(),'%Y-%m...')` #51031

Data type default values support `DATE_FORMAT(NOW(),'%Y-%m...')` #51031

zimulala commented Feb 7, 2024 •

edited

Loading