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
PHP
jQuery
Java
NLS_LANG
SQL SERVER
PL/SQL Collections and Records
DBMS_OUTPUT built-in package
Date and Time
PL/SQL Transactions
Ref Cursors
Bulk Binds
PL/SQL Analytic Functions
Problems and solves
Oracle Indexes
Oracle Courses
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment