Oracle Enterprise Solutions & Architecture
Pages
Home
Oracle APEX Change Management System | Yasser Hassan Portfolio
Oracle Change Management System Demo
SQL Fundamentals
SQL Fundamentals II
PHP
SQL PLUS
PL/SQL
Forms and Reports
HTML5
JavaScript
Java
PL/SQL Collections and Records
PL/SQL Transactions
Ref Cursors
PL/SQL Analytic Functions
Problems and solves
Oracle Indexes
Work Samples
Record & Collection
Conditional statements
LOOP
Triggers
Object Oriented
NLS_LANG
Oracle Interview Question
About Me
Contact Me
Privacy Policy
Monday, September 28, 2015
Oracle Convert datetime to number
you have to convert first to char with no spaces and then convert to number and here is the example for that
select to_number(to_char(sysdate,'hh24mi'))
from dual
;
Yasser
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment