Yasser Oracle Blog Dive in Oracle with Yasser, Oracle Developer Courses
Pages
Home
SQL Fundamentals
SQL Fundamentals II
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
PHP
Work Samples
Record & Collection
LOOP
Conditional statements
Triggers
Object Oriented
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