hi my query is SELECT NOW() out put is 2008-11-11 12:45:34' but i want to display 11-11-2008 12:45:34' in mysql how to do