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.

possible duplicate of http://stackoverflow.com/questions/2647 — jerry, Jun 18 '13 at 14:21

score 1 · Accepted Answer · edited May 23 '17 at 11:56

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!

edited May 23 '17 at 11:56

Community

answered Jun 17 '13 at 13:53

Anshuman

1 Answers1