Hi everyone, can you tell me how to calculate how long the customer got? Having the following information

----------------------------------------------- data_zakaza | data_poluchen | 15/03/2017 16/03/2017 17/03/2017 19/03/2018 3/16/2017 12:59 3/16/2017 14:59

date data type for both the result should be data_poluchen - data_zaka = time taken for delivery

  • And what exactly should the result be for the given data? It is also desirable to indicate what type these columns have in the database. - Yaant
  • Added information. - Smoke
  • one
    @ SmokBelyu You have not answered what result you want to see. Months, weeks, days, hours, minutes. The most trivial way looks like select data_poluchen-data_zakaza from table and it’s not clear what it doesn’t suit you. - Viktorov
  • ru.stackoverflow.com/questions/498722/… - Viktorov

0