Formatting a datetime column

[David]

I am using .Net 2.0 and VS2005 with SQL server db. The datetime columns on
SQL have the date and time in them. How can I display just the short date
format (e.g. a datetime of 10/19/2006 11:23:57 AM to show as just
10/19/2006)? I do not want to use the SQL CONVERT on the query because it
affects the sorting of the column in a GridView. If I leave the date and
time together, I get the correct sort. Below is a sample of my textbox on
the GridView column:

<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("updated_datetime")
%>'></asp:TextBox>

Thank you.

David

 

[Karl Seguin [MVP]]

Bind accepts a 2nd parameter which is the format

You can use a standard format:
http://msdn2.microsoft.com/en-us/library/az4se3k1.aspx

Bind("XXX", "{0:d}")

or a custom format:
http://msdn2.microsoft.com/en-us/library/8kb3ddd4.aspx

Bind("XXX", "{0:dd MM yyyy}")


Karl

 

[David]

Thanks. Do you need htmlencode="false" when you do this inside of the
BIND() ?

David

"Karl Seguin [MVP]" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME
net> wrote in message news:[email protected]...

 

[Karl Seguin [MVP]]

don't think so...

Karl

--
http://www.openmymind.net/
http://www.fuelindustries.com/

Thanks. Do you need htmlencode="false" when you do this inside of the
BIND() ?

David

"Karl Seguin [MVP]" <karl REMOVE @ REMOVE openmymind REMOVEMETOO . ANDME
net> wrote in message news:[email protected]...