28-Conversion Functions in SQL | Types of SQL Functions| CAST VS CONVERT | STR_TO_DATE | DATE_FORMAT

[@vipinkathait6070]

SELECT STR_TO_DATE('Sunday 04 June 2023 12:15 (pm)', '%W %d %M %Y %h:%i (%p)') AS formatted_datetime;

[@Cake-bz5bf]

Hello mam how you doing, just wanted to say pls make a detailed video on nested/subquery of sql as i have been always confused in that. Pls make a video about that from basic to advance.😊

[@CodeEra2020]

Okay sure. Thank you so much for watching

[@manishverma1025]

Very nice explanation

[@passportbro904]

I think for the cast one its better to show the actual decimal point for a better example. ill help you. SELECT CAST(10 AS DECIMAL(5, 2)) AS decimal_value; result = decimal_value 10.00

[@kapilrathore3649]

thanks for content

[@ranaprathap8292]

Please explain the any testing side

[@hajarigupta121]

Select STR_To_DATE (‘04-06-2023’,’%D-%M-%Y’)

[@Sairam45269]

In Sql server 2019 it is work or not

[@G.Rajini888]

Mam lexical functions ante entii quickly reply

[@shoryagupta7786]

Hi I am trying to convert str as ‘2019-12-24-12:12:34’ to timestamp My syntax is select str_to_ date(‘2019-12-24-12:12:34’, “%Y-%M-%D-%h:%i:%s”) But i am getting nulls Please help me

[@Santhosh-lt2rp]

Yes exactly 😮

[@vipinkathait6070]

Use format according to string then you will get the right answer - SELECT STR_TO_DATE('Sunday 04 June 2023 12:15 (pm)', '%W %d %M %Y %h:%i (%p)') AS formatted_datetime;

[@vineelsai111]

SELECT STR_TO_DATE('04 JUNE 2023 12:15:00','%d %m %Y %H %i') AS new_date; null coming what is wrong

[@sumitbarve7838]

you

[@star0475]

@@sumitbarve7838 bruh

[@mohamedhizam7398]

Xampp