select date_format(now() ," %a %M") from dual; # %c and %m same select date_format( now(),"current hour is %h ") from dual; # % h is number of hour ...