Blog

lucene solr 4: up and running

Solr: This is the Lucene based search api. Solr is open source enterprise search platform and written in Java, It provides the fast search with simple search, hit highlighting, faceted search, near real-time indexing, dynamic clustering, database integration, rich...
Date manipulation using SQL query
8 Sep, 14

Date manipulation using SQL query

I have written some useful query. When you need some customization in date format and find some prior date using SQL then below query might be useful for you. Find prior/future date from the current/given date: SELECT now()::date + 2 AS date1, current_date -1 AS date2...