Try this in your query: TIME_FORMAT(timeDb, '%H:%i') as timefield
http://www.java2s.com/Tutorial/MySQL/0280__Date-Time-Functions/TIMEFORMATtimeformat.htm -- View this message in context: http://lucene.472066.n3.nabble.com/how-to-convert-YYYY-MM-DD-to-YYY-MM-DD-hh-mm-ss-DIH-tp2961481p2961591.html Sent from the Solr - User mailing list archive at Nabble.com.