Ad:

ASP.NET Discussion Thread
Unsolved
Views: 32788

Dec 29th, 2006

How to split datetime format?

Expand Post »

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

Similar Threads

Want Date Format in dd/mm/yyyy in ASP.Net With C#. in C#
datetime format in ms sql in MS SQL
datetime format in MS SQL
need urgent help for a query in MS SQL
Log file rotation script in Perl

satees

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

15 posts
since Nov 2006

Permalink

Dec 29th, 2006

Re: How to split datetime format?

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.

nikkiH

Reputation Points: 13

Solved Threads: 4

Junior Poster in Training

Offline

79 posts
since Dec 2006

Permalink

Dec 30th, 2006

Re: How to split datetime format?

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.

Paladine

Team Colleague

Reputation Points: 211

Solved Threads: 27

Master Poster

Offline

793 posts
since Feb 2003

Permalink

Jan 3rd, 2007

Re: How to split datetime format?

If its in a gridview, something like this works

ASP.NET Syntax (Toggle Plain Text)

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

The whole grdiview might look something like this

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>

Last edited by Paladine; Jan 4th, 2007 at 8:17 pm. Reason: Adding Code Blocks

showtime

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

3 posts
since Jun 2006

Permalink

Nov 7th, 2007

Re: How to split datetime format?

you should check this out: http://developerstips.wordpress.com/...umn-in-aspnet/

dsa

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Nov 2007

Permalink

Nov 7th, 2007

Re: How to split datetime format?

This post is 11 months old.. why bring it up unless you have a question?

SheSaidImaPregy

Reputation Points: 43

Solved Threads: 68

Veteran Poster

Offline

1,080 posts
since Sep 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP.NET Forum Timeline: background-color:"9E0039" works in IE but not mozilla, solution?

Next Thread in ASP.NET Forum Timeline: Content Changes across pages via Drop-Down Box

DaniWeb Message

Cancel Changes

User Name
Password