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
Arup Rakshit