March 18, 2011 at 11:36 am
Hi.
When I open a table with the option "Edit all rows" for small tables, the columns with any of date format allways is showing as YYYY-MM-DD HH:MM.....
I would like to use other format like "DD/MM/YYYY HH:MM", but I don´t find the answer.
Thanks.
March 18, 2011 at 11:41 am
Don't use SSMS for that. Don't your databases have applications or web pages as a front-end and presentation layer?
If you really need to bypass all of the usual layers for an application and modify data directly in the database, use T-SQL scripts, not manual edits through the datagrid function in SSMS. (It's just a basic .NET datagrid built on top of an updatable cursor.) But using SSMS as a front end for your database that way is almost always a bad idea.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply