How to Display Timestamps from MS SQL 2000?

thetwai · March 13th, 2007, 01:30 AM

I want to display Timestamps column from MS SQL 2000 in this format 27-Mar-2007 If anybody know, pls help me Thanks, TW

dparsons · March 13th, 2007, 07:43 AM

In SQL you can do:

SELECT Convert(varchar(10), dateField, 106) From [table]
This will reutrn: 27 Mar 2007

To get your exact format you could just select the date field from your database and provide it as the string as in the example below:

String.Format("{0:dd-MMM-yyyy}", [value from SQL]);

hth

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========