Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > removing the time portion of date field

Reply
Thread Tools

removing the time portion of date field

 
 
Serge Poirier
Guest
Posts: n/a
 
      11-08-2003
Good Day Folks,

I'm displaying a date field from an Oracle table in a
datagrid with the following template.

<ItemTemplate>
<asp:Label id="hiredate" runat="server"
Text='<%# DataBinder.Eval
(Container.DataItem,"hiredate","{0:d}") %>'>
</asp:Label>
</ItemTemplate>

Does anyone know which date/time formatting string would
remove the time portion of the field ?

Thanks in advance
/serge
 
Reply With Quote
 
 
 
 
Lyndon Hills
Guest
Posts: n/a
 
      11-08-2003
On Fri, 7 Nov 2003 18:41:26 -0800, "Serge Poirier"
<(E-Mail Removed)> wrote:

>Good Day Folks,
>
>I'm displaying a date field from an Oracle table in a
>datagrid with the following template.
>
><ItemTemplate>
><asp:Label id="hiredate" runat="server"
>Text='<%# DataBinder.Eval
>(Container.DataItem,"hiredate","{0:d}") %>'>
></asp:Label>
></ItemTemplate>
>
>Does anyone know which date/time formatting string would
>remove the time portion of the field ?
>
>Thanks in advance
>/serge

Why not remove it when you retrieve the date from oracle? SELECT
TRUNC(date_col);
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: interpreting the fractional portion of time.clock() vs time.time(0measurements Peter Hansen Python 0 02-22-2006 02:02 PM
Re: interpreting the fractional portion of time.clock() vs time.time()measurements Peter Hansen Python 0 02-22-2006 12:03 AM
Append time to selected small date time field gil ASP General 1 04-16-2005 07:27 AM
Problem sending date to SQL date time field Robin ASP .Net 2 08-04-2004 05:27 PM
Date, date date date.... Peter Grison Java 10 05-30-2004 01:20 PM



Advertisments