Hello,
You can use one of these ...
in your statement write the date like the following:
select to_char(HIRE_DATE, 'dy/mon/rrrr')
from employees
or just like mbanavige said:
<asp:GridView ID="GridView1" runat="server">
<Columns>
<asp:BoundField DataField="yourDateField" DataFormatString="{0:d}" HtmlEncode="False" />
</Columns>
</asp:GridView>
Please, let me know if that helped ...
Please, “Mark as Answer” the post that helped you.