date format

Question

How does one remove or avoid the time part from a date/time field value. For example stored in database as  9/15/2012 11:36:06 AM ,but we have to retrive in label as 15/9/2012 only from table....