Format result of sp_helpdb
This is a discussion on Format result of sp_helpdb within the SQL Server forums, part of the Microsoft SQL Server category; --> Hello. How to format field "create" (Jan 12 2005) in sp_helpdb procedure to sth like yyyy-mm-dd (2005-01-12) in SQL? ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 06:25 AM
| ||||
| ||||
 Format result of sp_helpdb Hello. How to format field "create" (Jan 12 2005) in sp_helpdb procedure to sth like yyyy-mm-dd (2005-01-12) in SQL? bye... -- __ __ |__\\ | || |_// / \\ \_// FreeBSD: The Power To Serve |__// |__|| | \\ \__// / \\ +------------------------------+ +[ http://bukox.prv.pl ][ http://total.bukox.dmkproject.pl ]+      |
|
02-29-2008, 06:25 AM
| ||||
| ||||
| Re: Format result of sp_helpdb [BuKoX] (bukoxSPAMEROM_MOWIMY_NIE@tlen.pl) writes: > How to format field "create" (Jan 12 2005) in sp_helpdb > procedure to sth like yyyy-mm-dd (2005-01-12) in SQL? You would have to write your own version of sp_helpdb to that end. While the source code is in master, I don't think it's worth the effort for such a little change. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp |
Linear Mode
