Oracle Enterprise Solutions & Architecture
Pages
(Move to ...)
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
ِAbout & Consulting
Contact Me
▼
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
‹
›
Home
View web version
No comments:
Post a Comment