<div>
Hi!<br />
<br />
<br />
Just query it like<br />
<br />
SELECT CONVERT(VARCHAR(10),GETDAT<wbr />E(),10)
</div>


Hi!


Just query it like

SELECT CONVERT(VARCHAR(10),GETDATE(),10)

<div>
<div class="content wysiwyg-content">
Hi everyone, I have a question that i like to seek some help. Currently, below is part of my gridview code to display a datetime for a field &quot;CallClosed&quot; in my SQL database.<br />
<br />
<br />
&lt;asp:TemplateField HeaderText=&quot;Call Closed&quot; &gt;<br />
&nbsp;&lt;ItemTemplate&gt;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;%# (DateTime)Eval(&quot;CallClosed<wbr />&quot;) &lt;&nbsp;(new DateTime(1980, 1, 1)) ? &quot;&quot;&nbsp;: ((DateTime)Eval(&quot;CallClose<wbr />d&quot;)).ToStr<wbr />ing(&quot;dd/MM<wbr />M/yyyy &nbsp;HH:mm&quot;)%&gt;<br />
&lt;/ItemTemplate&gt;&lt;/asp:Templ<wbr />ateField&gt;<br />
<br />
How do i rewrite the statement to replace each field in dd/MMM/yyyy HH:mm with &quot;-&quot; if the datetime is 01/01/1980, else otherwise just display the datetime from my database in the gridview.<br />
<br />
Many Thanks!
</div>
</div>


Hi everyone, I have a question that i like to seek some help. Currently, below is part of my gridview code to display a datetime for a field "CallClosed" in my SQL database.


<asp:TemplateField HeaderText="Call Closed" >
 <ItemTemplate>
                    <%# (DateTime)Eval("CallClosed") < (new DateTime(1980, 1, 1)) ? "" : ((DateTime)Eval("CallClosed")).ToString("dd/MMM/yyyy  HH:mm")%>
</ItemTemplate></asp:TemplateField>

How do i rewrite the statement to replace each field in dd/MMM/yyyy HH:mm with "-" if the datetime is 01/01/1980, else otherwise just display the datetime from my database in the gridview.

Many Thanks!

Replacing a Dateline with &quot;-&quot; in gridview

Web development software is used to create websites for both the Internet and intranets. Software can be either locally installed or operated through a cloud interface, and ranges in complexity from simple text editors to full-fledged integrated development environments (IDEs) that include graphics, video, audio, scripting and database support.

Replacing a Dateline with &quot;-&quot; in gridview

Replacing a Dateline with "-" in gridview