SQL> select serialno, serialname, director, to_char (timeinindia,'dd-mon-yyyy hh:mi:ss a.m.') from serial_master;