how format string

[jason_mf]

I want to format date like "yyyy-mm-dd" when binding, but it can't like this "<%# Bind("Birthday","{yyyy-mm-dd}") %>"

[Harini N K]

Hi Are you binding data from database? You can do it in SQL Query using the convert() function as given below: SELECT CONVERT(NVARCHAR(10),Birthday,121) AS Birthday FROM Table1

Harini

[jason_mf]

It can not be formatted in asp.net? if it can ,I want to learning.

[Harini N K]

Then try this when binding data: DateTime DtmDate = DateTime.Now; System.Globalization.DateTimeFormatInfo dfi = new System.Globalization.DateTimeFormatInfo(); dfi.ShortDatePattern = "yyyy-MM-dd"; Response.Write(DtmDate.ToString("d", dfi));

Harini

modified on Wednesday, April 30, 2008 1:35 AM

[ChrisKo 0]

<%# Eval("Birthday", "{0:yyy-mm-dd}") %>