How to split a string column based on '/' in sqlserver 2005?

Question

Hi

I don't know how to split a dd/mm/yyyy column into dd as Col1, mm as Col2, yyyy as Col3. It is a string Field, so I can't use Select Convert() query.

Community · Accepted Answer · 2017-05-23 11:56:02Z

1

I found this as helpful when I was doing a similar thing a few days ago: T-SQL split string

Just play around with that code and you will get your solution!

Cheers!

CommunityBot

11 silver badge

answered Jun 17, 2013 at 13:53

Anshuman

5871 gold badge8 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1