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

[@snakebaboo4116]

I have learnt Date functions in full from your videos and it's awesome. Your way of teaching is easy to understand. Thanks for sharing your knowledge ✨

[@SivaAcademy]

my pleasure, thank you

[@krishnareddy2885]

Hello sir...... Really ur sharing very much usefull and interesting concepts at free of Cost....even if we take course also they will not teach these much depth subject....

[@SivaAcademy]

My pleasure 💐

[@rashmikumari3732]

Helo sir,thankyou for such great efforts..in love with these videos...

[@SivaAcademy]

Welcome 🙏💐

[@sakshinaik05]

Wow interesting tricks on date function

[@sphoortikushwaha9958]

Hi , your videos are very helpful to understand the points logically

[@SivaAcademy]

Glad to hear that!

[@rahulmittal116]

Excellent video !!

[@SivaAcademy]

Thank you

[@option_guy666]

Great job...(thanks a lot)

[@SivaAcademy]

Welcome 💐 bro

[@SureshPrajapati-ip2hx]

Its very useful video😊

[@SivaAcademy]

Welcome 💐

[@DatabaseAlok]

thanks sir

[@balag6621]

Nice explanation👌👌 How to display the last 3 records without using rownum and analytical functions.

[@rahulmittal116]

Using self join and correlated subquery

[@amitajhariya9521]

Siva sir plz share performance tuning video

[@SivaAcademy]

Sure bro, please stay tuned

[@prathameshsakpal66]

Is there any isdate function available in redshift. I want to pass a variable or column into the function and find out whether that variable or column value are date or not.

[@prathameshsakpal66]

If you can help me giving SQL query also fine. In redshift isdate convert,format is not working

[@SivaAcademy]

If you are passing a string, and if you are able to send the format of string, then it's possible, just checking only a string for valid date is difficult

[@sphoortikushwaha9958]

select to_char(sysdate,'DAY') from dual then it'll give the day name of the current date but it's considering the space . For ex- today is TUESDAY the it'll return TUESDAY with space.Can you please let us v know the logic behind it and share date function videos also like next_day,add_months etc.

[@mrarpitmore6189]

Good explanation

[@SivaAcademy]

Welcome 💐

[@mrarpitmore6189]

All clear sir

[@SivaAcademy]

My pleasure

[@Nidheeshmtr]

How we can store only the time in a column...? Like 12:02:10

[@SivaAcademy]

There is no Data type to support only to store the time componet, however we can use char datatype column to store the data, and can use the to_char function to extract the time from date and store in char column

[@bharadwajgand9532]

Please explain bulk exceptions

[@SivaAcademy]

Yeah, will be posting soon, please stay tuned

[@mrarpitmore6189]

Thank you sir

[@SivaAcademy]

Welcome bro 💐

[@pradeepverma8277]

😎🙏 nice viedo

[@SivaAcademy]

Welcome bro