select to_date('03/17/2008 06:30 AM','MM/DD/YYYY HH:MI AM') + (1800/86400) from dual;
if this not helps can you be more presize what the result you want.
Hope it helps.
-Manas
=======================================
If this post is useful to you, please mark it as answer.