How to change the format of DateTime.Date variable.

Hi,
I want to save the current date to a table in database. The coloumn type is declared as DateTime in the table, as i may have to select rows between two dates. So i can't change the format by converting it to string variable. I want the DateTime.Date variable to  have dd/MMM/yyyy hh:mm tt format instead of MM/dd/yyyy hh:mm:ss tt format.


Any help will be greatly appreciated.



...