in my data base i have a field which contains the date that the user joined. once i have taken that out of the database i want to create a new string which is the year from the other value. how would i do that.
ps. i only need to know how to do this
date user joined - 05/08/2004 10:26:23
from that ^ get this: year user joined - 2004