Filters in Photoshop are helpful tool to apply effects to any images. With new Oil Paint Filter of CS6 version, we can easily give any images a painted look.
All you need to do is open image in Photoshop, go to filter > Oil Paint and adjust the Brush and lighting settings as per your requirement.
Here is an example:
Before Image:
End Result: