ASP.NET

ASP.NET RSS

How to split datetime format?

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: Nov 2006

Posts: 15

Reputation: satees is an unknown quantity at this point

Solved Threads: 0

satees

Offline

Newbie Poster

How to split datetime format?

Dec 29th, 2006

Hi,

I have stored "DateTime" format in the database, but i need only "date" at the time of retrive. How to do this? Please help.

Thanks in advance.

Satees

•

Join Date: Dec 2006

Posts: 79

Reputation: nikkiH is an unknown quantity at this point

Solved Threads: 4

nikkiH

Offline

Junior Poster in Training

Re: How to split datetime format?

Dec 29th, 2006

You have a datetime. How you display it is up to you. The DateTime object supports multiple methods for displaying the date, as well as an overridden ToString that can take a format.
http://msdn2.microsoft.com/en-us/lib...e_methods.aspx

If for some reason you want it returned from the database as a string that is already formatted, the question is more relevant in an SQL forum, since it then becomes database dependent. SQL Server supports the convert function for dates, i.e.
convert(varchar,mydatefield,101)

Last edited by nikkiH; Dec 29th, 2006 at 9:56 am.

Google is your friend. I'm giving examples, not typing up your whole app for you. You run code at your own risk.
Bored? Visit http://www.kaelisspace.com/

•

Join Date: Feb 2003

Posts: 793

Reputation: Paladine has a spectacular aura about

Solved Threads: 27

Paladine

Offline

Master Poster

Re: How to split datetime format?

Dec 30th, 2006

Good points nikkiH!

One thing that can be done as well is to retrieve the date/time from the database as stored and use the parse/format methods in ASP.NET to produce the desired output.

Satees - the links nikkiH provide is an excellent starting point.

Last edited by Paladine; Dec 30th, 2006 at 3:27 pm.

Assistant Manager, Pharmacy Informatics
Wordpress Learning Blog
Updated : ASP.Net Login Code

•

Join Date: Jun 2006

Posts: 3

Reputation: showtime is an unknown quantity at this point

Solved Threads: 0

showtime

Offline

Newbie Poster

Re: How to split datetime format?

Jan 3rd, 2007

If its in a gridview, something like this works

Help with Code Tags

ASP.NET Syntax (Toggle Plain Text)

<%# String.Format("{0:d}",Eval("dtmExpiration")) %>

The whole grdiview might look something like this

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
                                                <asp:GridView Width="100%" BorderWidth="0" CellPadding="0" CellSpacing="0" BorderColor="white"
                                                    AutoGenerateColumns="FALSE" ShowHeader="false" ID="gvStores" runat="server">
                                                    <Columns>
                                                        <asp:TemplateField>
                                                            <ItemTemplate>
                                                                <table>
                                                                    <tr>
                                                                        <td valign="top" width="110px">
                                                                            <img border="0" src="images/<%# Eval("strLogo")%>" />
                                                                        </td>
                                                                        <td valign="top" class="bluebodytext">
                                                                            <%# Eval("txtDescription")%>
                                                                            <i>Offer Expires
                                                                                <%# String.Format("{0:d}",Eval("dtmExpiration")) %>
                                                                            </i>
                                                                        </td>
                                                                    </tr>
                                                                </table>
                                                                <div class="row">
                                                                    &nbsp;
                                                                </div>
                                                            </ItemTemplate>
                                                        </asp:TemplateField>
                                                    </Columns>
                                                </asp:GridView>
                                                <asp:GridView Width="100%" BorderWidth="0" CellPadding="0" CellSpacing="0" BorderColor="white"
                                                    AutoGenerateColumns="FALSE" ShowHeader="false" ID="gvStores" runat="server">
                                                    <Columns>
                                                        <asp:TemplateField>
                                                            <ItemTemplate>
                                                                <table>
                                                                    <tr>
                                                                        <td valign="top" width="110px">
                                                                            <img border="0" src="images/<%# Eval("strLogo")%>" />
                                                                        </td>
                                                                        <td valign="top" class="bluebodytext">
                                                                            <%# Eval("txtDescription")%>
                                                                            <i>Offer Expires
                                                                                <%# String.Format("{0:d}",Eval("dtmExpiration")) %>
                                                                            </i>
                                                                        </td>
                                                                    </tr>
                                                                </table>
                                                                <div class="row">
                                                                    &nbsp;
                                                                </div>
                                                            </ItemTemplate>
                                                        </asp:TemplateField>
                                                    </Columns>
                                                </asp:GridView>