Question: I am new to firefox extension development. Can somebody kindly tell me the languages which i should know and the tool which are required to be installed on my Windows machine. 

It would be really helpful for me if you can refer me some good tutorial links.

Answer: 
select date\_format(date\_column, '%d/%c/%Y - %H:%i:%s');

for a list of all the modifiers see <http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date-format>
Please check MySQL's [`date_format`](http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date-format) function.