Tuesday, October 29, 2013

Oracle: convert timestamp with timezone into date type

Simply add 0
select current_timestamp+0 from dual;