The syntax:
SELECT to_char(INSERTDATETIME,'YYY-MM-DD HH24:MI:SS') FROM tablename WHERE conditions
Published with Blogger-droid v2.0.2
ORACLE PL/SQL: Change Date/Time format display
Subscribe to:
Post Comments (Atom)
My Blog List
-
-
-
Herlan's Pre Weddings15 years ago
-
On Albums15 years ago
-
Sungei Buloh (Singapore)15 years ago
-
0 comments:
Post a Comment