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

[@karnarajmahajan8861]

Sir I'm professional. For interviews​ I refer your interview playlist. It's very useful. Thanks for your efforts.

[@SivaAcademy]

@Karnaraj, Thank you :-)

[@chadaradaarpitha4535]

I am obsessed with your videos when ever I need information about PL/SQL concepts thank you for these videos

[@SivaAcademy]

My pleasure 💐🙏

[@learnwithrajkumar252]

Ur videos are awesome one day u will get recognized from all Oracle plsql people's.

[@SivaAcademy]

@Research and Believe, Thank you bro....🙏.....Its my pleasure to read this comment :-)......Thanks Siva

[@tusharsonwane8468]

Thank you so much..sir i have never found teacher like you who explain date in such way🙏

[@SivaAcademy]

Thank you bro

[@rahulbadhe5930]

it's a very nice session sir every date components are very important, will know to each developer. thank you.

[@SivaAcademy]

@Rahul, Thank you bro....🙏

[@vijiinfo]

Thanks for considering my comment . Expecting normalaization with simple project design 😍😍😍

[@SivaAcademy]

@Viji, Its my pleasure Viji, Thank you....🙏.... Sure will post. i may take some time for normalization video, because, i always want to post with right set of example to make it as easy to understand...however i will definitely post...please stay tuned...Siva

[@sasimeeras5310]

Thanks sir your videos are very helpful to learn more about oracle. keep on posting more videos.....

[@SivaAcademy]

Welcome, sure, please stay tuned for more video's

[@waseemAkram-qc2vm]

Really super sir, easily we can understand difficult topics from your videos

[@SivaAcademy]

It's my pleasure. Thanks for your comment :-)

[@rahulmittal116]

Excellent video on dates.. How u explain.. even complex things looks simpler...Thanks Siva ...

[@SivaAcademy]

My pleasure, welcome bro 💐💐

[@sakthimuruganrm5849]

hi.. can anyone tell me 1st iso week is considered based on either thursday or friday??

[@nishantchawda406]

so clean and easy to understand. thankyou

[@SivaAcademy]

Welcome bro

[@sujaa1000]

Very nicely explained and understanding is very easy, thank you very much Siva. Regards, Sujaa

[@SivaAcademy]

Thank you so much 🙂

[@kirangunupati6433]

Hi, how to update only year to 2020 for date column in one table( which has different dates already)

[@swethaeamani]

Sir your explanation is good and easy to understand.Please make complete SQL and pl SQL tutorials

[@SivaAcademy]

Welcome, As soon as possible, pls stay tuned

[@abhijitmane9949]

Simply Awesome, Thanks :)

[@SivaAcademy]

Welcome bro

[@pankajkharade6936]

Nice work sir 👍👍👍 Also thanks for giving suggestion for trimming while extracting from date because I faced that problem already before

[@SivaAcademy]

Always welcome

[@abhaybhardwaj2224]

TO_DATE(&1, 'YYYY-MM-DD') what does this mean .. how do i execute it

[@sravaniseelam537]

Please add detail explaination on string functions sir .. specially regular expressions as they are very confusing

[@SivaAcademy]

Sure, please stay tuned 👍

[@ranjithkumar5259]

Thanks for giving learning experience

[@SivaAcademy]

Welcome bro

[@mdsiddiq7349]

Thank you sir very helpful video 😊

[@SivaAcademy]

Welcome bro

[@VijayKumar-eq2te]

sir how to find no of weeks in a month ?????

[@yashpatil6147]

Please tell explain and give tips about PLSQL

[@SivaAcademy]

Sure, please stay tuned

[@hhhhh00000]

Very well explained. Thank you.

[@SivaAcademy]

Thank you

[@kdeepika6482]

Hi sir is it possible to truncate all tables through procedures

[@SivaAcademy]

Yes, please use dynamic SQL

[@shashank2004]

Nice explanation sir, pls make a video on reverse key index in which scenario we ll be go to create reverse key index? How its work internally? Interviewer asked about same

[@SivaAcademy]

@Shashak, I have covred the reverse key index as part of index related video series. Please look into this video and let me know your feedback. kzbin.info/www/bejne/jWjdnpJti7GDa8U

[@amanpandey4907]

Dear Siva, Can you help me out with a query asked during interview. Need to provide date of first day,last day of the week provided inputs are month-year and week number example1- inputs- Aug-2021 and week- 3 then output- 15-Aug-2021,21-aug-2021 example2- inputs- July-2021 and week- 2 then output- 11-July-2021,17-july-2021

[@SivaAcademy]

Yes bro, will post it tomorrow morning under subscriber question series, please stay tuned

[@tarunmahajan4050]

your videos make crystal clear concept... thnks for good work

[@SivaAcademy]

Thanks for your comments bro 🙏

[@tarunmahajan4050]

Do you post videos on informatica ETL also ? If no, can you suggest something on that.. It will be a great help

[@vijiinfo]

You could have make another video for date function usage in Sql ... like first day of the month , last day of previous month , what happen with date TRUNC AND ROUND

[@SivaAcademy]

@Viji, yeah viji, infact, thats the reason I started as a new series for date, in fact i have started work the another video in the same series regarding YYYY and RRRR format asked by one of the subscriber, sure i will cover all the date related information here, but due to some other videos, its getting delayed....please stay tuned...

[@vaishuprabhakar1765]

Very nice sir

[@sajaljain2885]

shukriya, i have learned Date function

[@SivaAcademy]

My pleasure 💐💐🙏

[@gsraj511]

Thanks Siva

[@SivaAcademy]

Welcome bro

[@robertcrues]

Nice. It is possible to get source code of Oracle defined functions?

[@SivaAcademy]

@robertcrues, i never tried yet, so i cannot comment now...If i get to know, i will update you back.

[@robertcrues]

@@SivaAcademy thank you

[@sophiajose1797]

Side please provide the last query in this video we can't read the last line of the query

[@SivaAcademy]

with d as ( select to_date('31/12/2018','DD/MM/YYYY') as dt from dual) select c_date,trim(to_char(c_date,'DY')) day, to_char(c_date,'W') week_of_month, to_char(c_date,'WW') week_of_year, to_char(c_date,'IW') iso_week_of_month from( select trunc(d.dt,'MONTH')+level-1 c_date from d connect by level

[@vijayalakshmi-zq6iu]

Thank u sir.. 👌👌👌👌

[@SivaAcademy]

Welcome 💐🙏

[@sridhartamilselvan]

Really great job sir... Well done... Sir can we use RRRR instead of YYYY.

[@SivaAcademy]

@Sridhar, Thank you....🙏... Sure, will cover RRRR and YYYY in next video. Please stay tuned.

[@shaikmahaboob108]

Excellent sir

[@SivaAcademy]

@Shaik, Thank your....🙏

[@everythingintamil-9781]

I am Waiting for your python videos from so long.. please create for us.🙏

[@SivaAcademy]

Sure bro, please suggest some topics to start with

[@everythingintamil-9781]

@@SivaAcademy Beginning we can start from data structures and one by one other topics...my expectation, I want to know real time python project details and how python helpful for data science....numpy and pandas packages 🙏🙏🙏 Thanks you for responding all viewers🔥

[@SivaAcademy]

Sure bro, let me do

[@ratheeshg1896]

Recorded morning 6 😮

[@gomathinama5876]

Super sir

[@SivaAcademy]

Thank you....🙏

[@mugilans18]

Great

[@SivaAcademy]

@Mugilan Thank you!!!

[@juno7893]

👏🏻👏🏻👏🏻

[@SivaAcademy]

🙏💐

[@lakshmikothapalli4368]

Hello sir