Here is my try : staging::=> select to_char(created_at,'DD/MM') || '/' || to_char(now(),'YYYY') as when from users; when ------------ 24/02/2014 28/02/2014 02/03/2014 01/03/2014 04/03/2014 02/03/2014 06/03/2014 07/05/2014 02/06/2014 06/06/2014 20/02/2014 20/02/2014 20/02/2014 20/06/2014 20/02/2014 (15 rows)
Can the same be done using any other clever trick ? Regards, Arup Rakshit