Sysdate to date format

Hi,

I have a target table with date field in MMDDYYYY format and it should be sysdate.

When i enter sysdate() function, i am getting it in the format YYYYMMDD. How can i convert sysdate() function to display MMDDYYYY?

Thanks,

Arun