Oracle ALL About Dates PART 3 | usage of ROUND and TRUNC function on dates and number data types

Показать описание

Oracle ALL About Dates PART 3 | usage of ROUND and TRUNC function on dates and number data types
--------------------------------------------------------------
This channel is for learning Oracle SQL, PLSQL, DATABASE concepts, MYSQL, ETL, Mongo DB, Python,UNIX and related technologies.
--------------------------------------------------------------

--------------------------------------------------------------

--------------------------------------------------------------

--------------------------------------------------------------
About Myself:
----------------------
I am Siva, [LEARN | CODE | TRAIN | SHARE].
Being in IT industry for more than 12+ years.
In my day to day job, I work with database technologies including Oracle, Java, Python, MongoDB, talend and UNIX.
I am passionate about "DATA", coding & training.
In my spare time, I teach database technologies , ETL etc.
I am very glad that you are reading my Profile, and I value your time as well as mine.
Looking forward to see you in my videos

--------------------------------------------------------------

Рекомендации по теме

Комментарии

Hi Siva
Siva Acadamy l has helped me a lot for a successful PLSQL interview.

Thank you very much

ajishmac.v

If anyone watches all the four parts with respect to Time and Dates, I do not think there is anything more required from your work life perspective. All the aspects are covered with good examples. Thank you very much...

sudheerkumarreddy

Excellent video...today my concepts for round and trunc are clear...
Thanks a lot Siva..
You are blessing for me !!

rahulmittal

Excellent video, thank you for such simple explanation

PawanKumar-gbpj

Sir, I am big fan of yours...I have watched all of your videos and your explanations are much informative and easy to understand.. If you can create a performance tuning video series of explain plan and hints, table partitioning, Oracle architecture etc.. then It would be greatfull.
Otherwise if you are providing online classes then how I will join your classes ? I got rejected many companies related to performance tuning topic only.
Thanks in advance

abhijitmohanty

Very nice.... superb explanation.... Thank you 🙂

SuNiLKuMaR-iqpz

super explanation sir.. thank u sir.. 👌👌👌👌👌

vijayalakshmi-zqiu

hi siva, select from dual; giving output as it should give

nntrainingandplacementsolu

For DAY as parameter, it takes the start day of the week. For DDD/DD it takes the start of the day. The default parameter is DDD.

JohnDavid-pwzx

Very good explanation sir but we are still waiting your SQL tuning video.

pradeepverma

Trunc(to-date(, 'month', -6) ?

Till month u told in video last

yallababus

Hi Shiva sir
Do you take online classes ? would like to take SQL/PLSQL classes.

Cherry-nxgv

could you explain this query output for me ??

i have written this following query to trunc and round the data by using dd fmt in the arguments field of trunc and round using the 09-12-22 as my sysdate

select sysdate, trunc(sysdate, 'dd'), round(sysdate, 'dd') from dual
/

SYSDATE TRUNC(SYSDATE, 'DD') ROUND(SYSDATE, 'DD')

09-dec-2022 10:27:57pm 09-dec-2022 12:00:00am 10-dec-2022 12:00:00am

why is it giving 09-dec-2022 as output when using it dd format for trun()??

ranjithparuchuri

Hi sir..
If it is possible
Talend lo
Generic schema meda vedio cheyandi sir.
Multiple files with different fields... Ni single file ga cheyali output lo

mohansai

Hi sir,
I have a very important question
For suppose, a date is like xtime= 24-FEB-22 00:24:48
NOW I WANT THIS DATE TO BE PRINTED AS
2022-FEB-24 00:24:00
ONLY the seconds need be truncated and date format should be changed as yyyy-mon-dd
When I'm trying
To_date(to_char('24-FEB-22', 'YYYY/MM/DD HH24:MM')||':00', 'YYYY/MM/DD HH24:MM:SS')
IM GETTING ERROR,
AND these date formats are predefined variables I need to use .
Please help me to correct it

craftshelf

Round (98765.13479, 2)
Ans?….

Pls reply

kidschannel

Hi Siva,
At 11:04 on this video, round(987654321.12579, -9) is 0 but I guess it should be 1 billion. May be a typo at your end

akshay

Oracle ALL About Dates PART 3 | usage of ROUND and TRUNC function on dates and number data types

Oracle ALL About Dates PART 1 Understanding Date Components | oracle date format specifiers

Oracle ALL About Dates PART 4 | Oracle Datetime Format Element Suffixes

Oracle ALL About Dates PART 2 Understanding YEAR Component YYYY vs RRRR

Oracle ALL About Dates PART 6 | INTERVAL DAY TO SECOND Data Type

Oracle ALL About Dates PART 5 INTERVAL YEAR TO MONTH Data Type

Oracle ALL About Dates PART 3 | usage of ROUND and TRUNC function on dates and number data types

How to use DATEs, TIMESTAMPs, and INTERVALs in Oracle Database

Working with Dates - Oracle SQL

August Happys

Database: Oracle dates and time

Oracle TO_DATE Function Explained with Examples

Date and Time functions in Oracle explained with Various Examples || Oracle Database Tutorial

Converting AM/PM Text Fields into Dates with Oracle Analytics

Oracle SQL Practical question | SQL to Get all dates for the given input month and year | date range

Working with dates in Oracle PLSQL.

Oracle SQL DATE Data Types | Oracle SQL fundamentals

Databases: Compare dates in Oracle SQL

Oracle || Oracle Number Functions Part -1 by Siva

Oracle Date Format

Oracle SQL: Generate All Dates Between Two Dates🔥#sql

Oracle Database Express SQL Tutorial 5 (dates)

Oracle SQL: Exploring Date Functions

SQL : How to get the differences between two dates in Oracle which were in same column?

Oracle Date Manipulations | Date Manipulations using SYSDATE | Oracle SYSDATE | Oracle SQL Tutorial