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/