StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POEval strips time segment of a SQL DateTime field
primarykey
Id
775739
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2009-04-22T04:53:21.853
FavoriteCount
0
LastActivityDate
2009-04-23T11:02:04.563
LastEditDate
2009-04-23T11:02:04.563
LastEditorUserId
17516
OwnerUserId
28939
ParentId
0
PostTypeId
1
Score
0
ViewCount
752
LastEditorDisplayName
text
Body
Was going to call this "Eval won't give me the Time of Day," but thought that too cute. I'm kind of having the opposite problem from the suggested questions I see for my title, so here goes: Visual Studio 2008 Pro, SQL Express 2008, Vista. Web Project, where I'm opening records from an Event Table with JOINed info from a Facilities table. I have a SQL DateTime field in a SQL file that is completely filled out: e.g., 4/30/2009 6:30 PM. My field in the ListView is straight <code><%# Eval("EventDate") %></code>, and my trace, as far as I have been able to tell from watching the Autos window through retrieval from the SQLDataSource, survives intact with the 6:30 PM time of day. The only instruction, to my knowledge, that comes after the DataSource is populated, is the Eval itself. Yet, at render time, that datetime comes out on the page as 4/30/2009 12:00:00 AM. My strong belief, therefore, is that I need additional fu to parse my Eval statement to get the same time I put into the field. I am not yet adept at this, so suggestions would be welcome. Thank you in advance. Edit: supplying code per Jose. DataSource: <code><asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MeetingsConnectionString %>" onselecting="SqlDataSource1_Selecting" SelectCommand="SELECT Events.ID, Events.FacilityID, Events.Room, Events.EventDate, Events.Speaker, Events.Topic, Facilities.ID AS Expr1, Facilities.FacilityName, Facilities.FacilityAddress, Facilities.FacilityCity, Facilities.FacilityState, Facilities.FacilityZip, Facilities.FacilityLat, Facilities.FacilityLong FROM Events INNER JOIN Facilities ON Events.FacilityID = Facilities.ID WHERE (Events.EventDate BETWEEN @EventDate AND @EventDate2) ORDER BY Events.EventDate" ProviderName="System.Data.SqlClient"> <SelectParameters> <asp:Parameter Name="EventDate" /> <asp:Parameter Name="EventDate2" /> </SelectParameters> </asp:SqlDataSource> </code> ListView: <code><asp:ListView ID="ListView1" runat="server" DataSourceID="SqlDataSource1" DataKeyNames="ID,Expr1"> <AlternatingItemTemplate> When:<asp:Label ID="EventDateLabel" runat="server" Text='<%# Eval("EventDate") %>' /> </code> ... <code><ItemTemplate> When: <asp:Label ID="EventDateLabel" runat="server" Text='<%# Eval("EventDate") %>' /> </code> Edit 2: I worked around the problem by separating EventDate into EventDate (a Date) and EventTime (a Time). I now get the proper values, and have moved on to conversion of the time value from military to civilian time (i.e., 6:30pm) in the SQL query using a CONVERT or CAST. Thanks for all of your responses.
Tags
<sql-server-2008><datetime><.net-3.5><eval>
Title
Eval strips time segment of a SQL DateTime field
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USAnthonyWJones
UserOwnerUserId
1. USJohn Dunagan
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.