How to consult a date that is after a given date sqlite?

Navigation
0

What I want to do is that if for example in a sqlite table I have the following data

DD / MM / YYY format 

  |   FECHA    |
  --------------
  | 06/12/2017 |
  | 24/7/2015  |
  | 2/10/2014  |
  | 13/1/2017  |
  | 06/11/2017 |

and when making a query select the dates before 23/6/2016 I returned 

     -------------
     | 24/7/2015 |
     | 2/10/2014 |
     -------------
    
asked by Juan Ar 02.07.2018 в 06:01
source

1 answer

0

You can use the following query statement, indicating that the date must be less than the requested date, in addition indicating the name of [TuTabla] 

select FECHA from [TuTabla] where date(FECHA ) < date('2016-06-23');
    
answered by 02.07.2018 в 06:34
Laravel 5.6: When I upload an image, it saves a path but not an image How to integrate Facebook leads to Mautic?