Selecting distinct yearr from unix_timestamp
Posted: Sat Feb 03, 2007 9:06 am
Hello,
I have a large number of unix_timestamps in mij database. Now I would like to retrieve all the distinct years from these timestamps to use them further on with PHP. Is it possible to do this an MySQL query? If not, is there a good way to this with PHP? Or should I change from unix_timestamp to datetime?
Thanx in advance for helping this newbie
!
I have a large number of unix_timestamps in mij database. Now I would like to retrieve all the distinct years from these timestamps to use them further on with PHP. Is it possible to do this an MySQL query? If not, is there a good way to this with PHP? Or should I change from unix_timestamp to datetime?
Thanx in advance for helping this newbie