TB
Member since Nov 9, 2009
- Profile: /members/4715-tb.htm
- Comments: 2
Recent Blog Comments By TB
-
Getting Only the Date Part of a Date/Time Stamp in SQL Server
Posted on Nov 9, 2009 at 5:28 PM
Mat- My understanding is that the desired end product was a straight text file. In this instance, datatype become irrelevant. In general I wouldn't advocate for switching a datetime field to any other format unless expressly required, but for this specific instance I believe my comment still stand... read more »
-
Getting Only the Date Part of a Date/Time Stamp in SQL Server
Posted on Nov 9, 2009 at 1:36 PM
Nic- Is there some reason you can't just convert the datetime field to a text field that only shows the date? If it's an email attachment from a straight SQL query the user can just copy/paste it into a spreadsheet and it should register as a date value. -TB... read more »