mysql> select * from employee where str_to_date(b_date,'%Y-%m-%d') between str_to_date('2019-2-26','%Y-%m-%d') and str_to_date('2019-2-30','%Y-%m-%d');
| id | name | b_date |
| 2 | tony stark | 2019-2-26 |
| 4 | black widow | 2019-2-27 |
2 rows in set (0.00 sec)
mysql> desc employee;
| Field | Type | Null | Key | Default | Extra |
| id | int(11) | NO | PRI | NULL | |
| name | varchar(20) | YES | | NULL | |
| b_date | varchar(20) | YES | | NULL | |
3 rows in set (0.03 sec)
mysql> select * from employee;
| id | name | b_date |
| 1 | steve rogers | 2019-2-24 |
| 2 | tony stark | 2019-2-26 |
| 3 | thor odinson | 2019-2-25 |
| 4 | black widow | 2019-2-27 |
4 rows in set (0.06 sec)
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, Dont forget to like share and subscribe.
