jeudi 16 avril 2015

How to get DATE from DATETIME column?

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