现在有一张表 dateA
字段有
Adate Bdate Cdate Ddate
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-03-31 2011-03-30 2011-05-30 00:00:00 2011-2-22 00:00:00
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-03-29 2011-03-30 2011-05-30 00:00:00 2011-2-22 00:00:00
2011-03-29 2011-03-29 2011-05-30 00:00:00 2011-2-22 00:00:00
2011-03-31 2011-03-29 2011-05-29 00:00:00 2011-2-22 00:00:00
2011-03-31 2011-03-30 2011-05-30 00:00:00 2011-2-22 00:00:00
表内信息如上,现在要将这张表的信息统一,Adate 统一为2011-06-15,Bdate统一为2011-09-15
Cdate统一为2011-12-30,Ddate统一为2012-01-30.请问谁能提供下SQL语句方法吗
字段有
Adate Bdate Cdate Ddate
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-03-31 2011-03-30 2011-05-30 00:00:00 2011-2-22 00:00:00
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-03-29 2011-03-30 2011-05-30 00:00:00 2011-2-22 00:00:00
2011-03-29 2011-03-29 2011-05-30 00:00:00 2011-2-22 00:00:00
2011-03-31 2011-03-29 2011-05-29 00:00:00 2011-2-22 00:00:00
2011-03-31 2011-03-30 2011-05-30 00:00:00 2011-2-22 00:00:00
表内信息如上,现在要将这张表的信息统一,Adate 统一为2011-06-15,Bdate统一为2011-09-15
Cdate统一为2011-12-30,Ddate统一为2012-01-30.请问谁能提供下SQL语句方法吗
adate = to_date('2011-06-05', 'yyyy-mm-dd'),
bdate = to_date('2011-09-15', 'yyyy-mm-dd'),
cdate = to_date('2011-12-30', 'yyyy-mm-dd'),
ddate = to_date('2011-01-30', 'yyyy-mm-dd');