Hi Manish,
select cast (current_timestamp as date) ;
should do it.
Cheers,
Tris.
Attachments
Library
Quick Reference
Archives
Sample Index
2004 Indexes