in my table I have a column Dates
10/03/2004 18:35:00
how can I get the list of Distinct years ?
2001
2002
2003
2004
thank youselect distinct year(Dates) from yourtable|||it works !
thank you
Showing posts with label 2001200220032004thank. Show all posts
Showing posts with label 2001200220032004thank. Show all posts
Subscribe to:
Posts (Atom)