Cast and Convert functions in SQL Server Part 28

Thank you, this was helpful !

Will This function also work for MYSQL or PostGress ?

Error has thrown

👍👍👍👍👍👍

we can follow this concepts because its 10 years old video plz conform

Tq so much sir....

Can you upload a Python tutorial for beginners?

Can anyone help I want both string and intigers at a time

how to connect with you?

One think i understands from his tutorial , if u want to be best you need a best guide

One of the best video even gone through...!! Thank you very much appreciated your efforts...!! Plz upload some unix command over here with good examples..

Thank you bro ur vidio is very useful for begginers

In 2021 we have the CONCAT function that can combine Int and Nvarchar. Cheeers!

Your explanation was very through. Thank you for making this video.

Thank you Venkat Sir your. Net core series is also perfect 👍👍

AWESOME SIR

Sir I have error ?

We can also use CONCAT function.
SELECT [Id], [Name]
, CONCAT([Name], ' - ', [Id]) AS [Name-Id]
FROM [dbo].[Employees]

Thank you Venkat !

Venkat, I have a question! Can we use this cast and convert only for a date or else for any other datatype like int, varchar, etc?

Hi. how may l convert date(text type) to date type. so my date is as 20 march 2020. and l want convert example: 20200320 (or 2020-03-20 etc). as l see it is differ than date to text type.

I dint get the result same as in this video and the function created in last video

How to convert one date format into another, Ex to_date(column name, 'yyyy-mm-dd') , Column \_nam format is yyyymmdd.

Thank you Kudvenkat, amazing videos on SQL. DO you have similar video's for SSAS and SSIS

Thank you very much for the explanation. I'm always following your videos to learn and find the solution related to SQL question. In one of my sql query result, I'm getting the error Conversion failed when converting the nvarchar value '`````````'to data type int. However, due to number of columns and tables in my query, I'm not able to find the exact value which cautioning the issue. Can please explain how can we find such values with multiple join tables and many columns. Thank you.

HI where can i get the DB you are working on.

Venkat Can we use Rollup query as GroupBy Rollup(Registration Date as Date)

It could be also convert
Convert (char(13),tablenameofdateofbirth,104)

how to convert mm to ft in

Hello sir, same as u explained in video i tried. But, getting the same values in nvarchar also.

i have two column id and nane id 1 name salmankhan i want to split name like fname= salman and lname =khan into seprate column

sir make video on performance of query ans SSIS

HI BRO IF I EXECUTE THIS
SELECT CAST('1993.06.19' AS nvarchar)
IT IS STILL LIKE "1993.06.19"
I AM USING SQL 2012
BUT IN YOUR EXAMPLE IT WOULD BE LIKE JUNE 6 1993
HOW DO I SOLVE THIS PROBLEM?

Thank you bro

Hi sir
When I am converting Date to integer or decimal using cast and convert, it's reflecting the date value less than its actual value.
Please suggest.

create procedure st_getShifts
as
select s.sh_id as 'ID',
s.sh_name as 'Name',
format(s.sh_fromTime,'hh:mm tt') as'From',
format(s.sh_toTime,'hh:mm tt') as'TO',
s.sh_number as 'Number'
from shifts s
error show WHEN EXUCUTE


Msg 195, Level 15, State 10, Procedure st_getShifts, Line 49
'format' is not a recognized built-in function name.
HOW SOLVE PLS HELP ME

Very detailed...and very nice explanation

Thank you!

perfect. Thanks a lot

how can i convert a video into a data in sql?

It is very help ful video for the Learners but in the in version 2014 it does not work and I try with following Syntax and it works.
SELECT ID, Name, DateOfBirth, CONVERT(VARCHAR(15), DateOfBirth,9) AS ConvertedDate FROM Employees
Result:

1 Sam 1980-12-30 Dec 30 1980
2 Pam 1982-09-01 Sep 1 1982
3 John 1985-08-22 Aug 22 1985
4 Sara 1979-11-29 Nov 29 1979

My date is stored in the varchar and I want to convert it to date type so that i can extract month and date from it. please help

please help

Hello sir, how to solve this problem ----->The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

I would a bit modify the title: "Best SQL Server tutorial ever - Part 28"

Love You Kudvenkat

that was amazing , you really solved my problems. thanks a lot

Write a query which returns the total number of registrations by Year?
select cast(datepart(year,doj)as int)as 'DOJ',count(id) from tblDate
group by cast(datepart(year,doj) as int)

Thanx! That's great ! It is very useful! You are great SQL teacher!