ORACLE PL/SQL: Change Date/Time format display

The syntax:

SELECT to_char(INSERTDATETIME,'YYY-MM-DD HH24:MI:SS') FROM tablename WHERE conditions


Published with Blogger-droid v2.0.2

0 comments:

Nice Blog!!