I want to get date from DateTime column.
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT [name], [book_id], [book_name], [taken_date], [last_date], [renewed_date], [status], [comment], [fine_amount] FROM [library] WHERE ([admn_no] = @admn_no)">
<SelectParameters>
<asp:ControlParameter ControlID="TextBox1" Name="admn_no" PropertyName="Text"
Type="String" />
</SelectParameters>
</asp:SqlDataSource>
From the above these [taken_date],[last_date],[renewed_date] columns showing date and time
(eg:
4/14/2015 12:00:00 AM).
How do I display only date
(eg:
4/14/2015)?
Aucun commentaire:
Enregistrer un commentaire