i am using oracle 10g as database, i have a textbox called Transaction date,
i want to save transaction date into column filed called TDate (Date),
actually i am using ajax calender extender to get date in the format of 23-sep-2010,
when i retrieve the record it shows me like 23-sep-2010 12:00:00 AM
i want to remove the time filed..i used query " select TDate from Tranaction where TID=1"
but it shows like this 23-sep-2010 12:00:00 AM,how to remove the time field