March 17, 2009 at 11:34 am
2/28/2009 12:00:00 AM
This is my current format.
How do I filter it into 2/28/2009 this format in sqlserver ? Is it good to filter it with T-sql at the database level or can I filter it in visual studio 2003 to finally show 2/28/2009 in this format on reporting services . How do I filter that in visual studio 2003 .
Which is a better option ?
Thanks!
March 17, 2009 at 11:43 am
If I understand what you mean, that you want to make a date and time look a certain way, do that in the front end (report/web page/form/whatever). Easier and allows different users to have different preferences if you set it up that way.
- 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
March 17, 2009 at 12:26 pm
I think it is better to have VS2003 to do the formatting. You have at least the following options: You can use the ToShortDateString method (which will use the Windows regional settings to format the date - so if they change the format will change) or you can use String.Format with a specific fomatting string.
---------------------------------------------
[font="Verdana"]Nothing is impossible.
It is just a matter of time and money.[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply