1、创建测试表,
create table test_times(id number, v_time timestamp);
2、插入测试数据
insert into test_times values(1,to_timestamp('1980-07-10 00:00:00.000', 'yyyy-mm-dd hh24:mi:ss.ff'));
insert into test_times values(2,to_timestamp('1980-07-12 00:00:00.000', 'yyyy-mm-dd hh24:mi:ss.ff'));
insert into test_times values(3,to_timestamp('1980-07-13 00:00:00.000', 'yyyy-mm-dd hh24:mi:ss.ff'));
commit;
3、查询表中全量数据,select t.*, rowid from test_times t;
4、编写sql,将日期后面的时间去掉;
select t.*, to_char(v_time,'yyyy-mm-dd') v2 from test_times t;