Star9
61
代码
代码
Issues137
Pull Requests38
流水线
讨论
Wiki
分析
Star9
61
bomoubomoufix(IBF444): timestamp(xxx, xx) 第二个参数传入时戳格式时改为返回 NULL，time'xxx' 传入时戳格式时改为 ERROR 报错
5fffac19创建于 2025年1月4日历史提交
create schema second_microsecond;
set current_schema to 'second_microsecond';
select microsecond(timestamp '2021-11-4 16:30:44.3411');
select second(timestamp(6) '2021-11-4 16:30:44.3411');
select microsecond(datetime '2021-11-4 16:30:44.3411');
select second(datetime(6) '2021-11-4 16:30:44.3411');
select microsecond(timestamptz '2021-11-4 16:30:44.3411');
select second(timestamptz(6) '2021-11-4 16:30:44.3411');
select microsecond(time('2021-11-4 16:30:44.3411'));
select second(time(6) '2021-11-4 16:30:44.3411');
select microsecond(timetz '2021-11-4 16:30:44.3411');
select second(timetz(6) '2021-11-4 16:30:44.3411');

drop schema second_microsecond cascade;
reset current_schema;