Скачать или смотреть MySql | Find Data Between Dates When Date Is Stored As Varchar | Str_to_date | Select Statement

Link to code :-
https://unpossiblepog.blogspot.com/20...

Hello guys, this is unpossible pog and in this video, I shall teach you how to find data between two dates if they are stored as varchar as variable character.

First I shall start mysql by entering username and password.
Then I shall connect to the database, this is case, its sys.

Then as you can see the employee data with the birth dates.
But the b_date is stored as varchar.


So in mysql, there is a function called str_to_date() which converts text to date.
So type command like this in where condition, the first argument will be the column name, which is b_date. Then in second argument, there will be a pattern.
In my database, the pattern is the year – month – date. So I shall type percentage year – percentage month – percentage date.

Thank you for watching, Don't forget to like share and subscribe.


Please avoid or flag spams/hateful comments. And do not spam.
Enjoy :)

Subscribe my Channel:-
http://www.youtube.com/user/SanketRoo...

Facebook Page:-
  / unpossiblens  

Twitter Account:-
  / unpossiblepog  

Blog :-
https://unpossiblepog.blogspot.in/