lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From roySolr <royrutten1...@gmail.com>
Subject Re: how to convert YYYY-MM-DD to YYY-MM-DD hh:mm:ss - DIH
Date Thu, 19 May 2011 14:29:04 GMT
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.

Mime
View raw message