Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How To Convert This Date
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
How To Convert This Date
Miscellaneous
Thread ID:
01448391
Message ID:
01448391
Views:
111
I have 96K rows with a Month column. The data is in the format:
YYYY-MM-Mon
So, '2009-11-Nov' is November, 2009 and '2009-02-Feb' is February. The middle 2 charaters are the month number.

I need to convert these to the first saturday of the month. Anyone know of a way to do this?
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Next
Reply
Map
View

Click here to load this message in the networking platform