Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
giviglie
Starting Member
5 Posts |
 Posted - 2010-03-15 : 12:40:37
|
| Hi, I can't solve this problem. I have a simple table called "Period" where I store the beginning date and the end date of an event.Event Begin EndEvent1 10-05-2010 15-05-2010When I select data from this table I would like to get a result like this:Event1 10-15 May Is this possible? Any help will be very appreciated!Cheers!!!!Giacomo |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-15 : 12:42:13
|
| this is a formatting issue and this should be done at front end using date formatting functions------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Date Format - Interval