Hi I am copying data from excel to sql server 2005.
But when I copy it, In the time column when I have written for example 19:00 then in sql server it will write: 30-12-1899 19:00:00
And when I wan't to extract it to my page it will write it out as: 30-12-1899 19:00:00
but I only wan't it to be written like this: 19:00 ?
My sql statement looks like this:
"SELECT * FROM PROGRAM WHERE DATE >= convert(varchar, GETDATE()) AND DATE <= DATEADD(Month, 2, GETDATE())";
and my code that extracts it looks like this:
<asp:Repeater ID="program" runat="server">
<ItemTemplate>
<table >
<tr>
<td style="vertical-align:top" id="program_txt">
<div id="txt_udsendelser"> <%# Eval("tid") %></td></div>
<td style="vertical-align:top" class="program_txt">
<%# Eval("txt")%></div> </td> <br />
</tr>
</table>
</ItemTemplate>
</asp:Repeater>
you can see the result here:
http://radio.web.surftown.dk/udsendelser.aspx
Hope someone can help?
Kischi