oracle将字符串转换为12小时与24小时制:
--12小时制:
select hsv.mydate from huhai_seq_value hsv
where hsv.mydate = to_date('2009-03-03 00:00:00','yyyy-mm-dd hh:mi:ss');
--24小时制:
select hsv.mydate from huhai_seq_value hsv
where hsv.mydate = to_date('2009-03-03 00:00:00','yyyy-mm-dd hh24:mi:ss');