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.😊
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
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
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;
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.😊
Okay sure. Thank you so much for watching
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
thanks for content
Very nice explanation
Please explain the any testing side
Select STR_To_DATE (‘04-06-2023’,’%D-%M-%Y’)
In Sql server 2019 it is work or not
Mam lexical functions ante entii quickly reply
SELECT STR_TO_DATE('Sunday 04 June 2023 12:15 (pm)', '%W %d %M %Y %h:%i (%p)') AS formatted_datetime;
SELECT STR_TO_DATE('04 JUNE 2023 12:15:00','%d %m %Y %H %i') AS new_date; null coming what is wrong
you
@@sumitbarve7838 bruh
Xampp
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
Yes exactly 😮
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;