Learn and shine
Friday, July 24, 2020
Convert Date to Number and Number to Date in Oracle
How we can convert date to number in oracle
select to_number(to_char(add_months(sysdate,-0),'yyyymm')) from dual;
How we can convert number to date
select to_char(to_date(202007,'yyyymm'),'dd-mon-yyyy') from dual;
1 comment:
derya
July 28, 2023 at 2:12 AM
afyon
muğla
batman
hakkari
artvin
QSB
Reply
Delete
Replies
Reply
Add comment
Load more...
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
AddToAny
Contact Form
Name
Email
*
Message
*
afyon
ReplyDeletemuğla
batman
hakkari
artvin
QSB