Format Gridview column

[BasicBoy]

There are a lot of replies as to formatting the gridview columns on databinding, but I found nothing on formatting the query.

There might be a query possible as follows (but I cannot get it right):

Select Format(MyDate,'dd-MMM-yy') from MyTable

Any help will be appreciated,

Thanks
BB

 

[jmeckley]

you wouldn't format the query, the query is just getting data. the UI presents the data. this is where formatting should occur.

You *can* convert datetime data types to varchar data types in MS SQL (and other databases as well) with

covert(varchar, [the date], 101)

I think that formats the date as 09/30/11. there are other formats as well. see BOL SQL help for details or post to the appropriate database forum.

Jason Meckley
Programmer

faq855-7190
faq732-7259