Date

[jonhbt]

I have a field in the database which is of type date time. When i return it in a grid view I want to remove the time and show only the date. Is it possible to show only the date? Thank you. PS I am showing the date by binding the grid view.

[pmarfleet]

The MSDN documentation has an article[^] on date/time format strings.

Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

[biswa47]

Ofcourse its possible, use substring() in sql. bofore dispaly data in the grid use substring in db

[Herman T Instance]

You can do a Convert(varchar, dateTime field, 105) for instance. More information: here[^]

[pmarfleet]

biswa47 wrote:

use substring() in sql. bofore dispaly data in the grid use substring in db

This isn't the right way to do it. The .NET Framework has support for formatting dates in different ways. See the link I provided in my original reply.

[pmarfleet]

digimanus wrote:

You can do a Convert(varchar, dateTime field, 105) for instance.

Date formatting should be done in the presentation layer. The .NET Framework provides built-in support for this. See the link in my original reply.

[Herman T Instance]

I think it CAN be done in .NET Let the poster of this problem decide what he wants to. things like: DateTime dateValue = DateTime.Now String whatTime = String.Format("{0:yyyyMMdd}", dateValue); can also be done.

[pmarfleet]

digimanus wrote:

Let the poster of this problem decide what he wants to.

This forum is a place for people to discuss solutions to problems. If I want to critisize other people's suggestions, I will do. I certainly don't need your permission. The basic fact of the matter is that using the T-SQL SUBSTRING is a clumsy way to format dates. If T-SQL must be used, the CONVERT function is better. IMHO, .NET provides a much richer API for data presentation and should be the tool of choice.

Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush