Date Search in sql

[data2base]

Background information

IMPORTANT: If you choose to ignore this issue report template, your issue will be closed as we cannot help without the requested information.

Please make sure you tick (add an x between the square brackets with no spaces) the following check boxes:

• [] Reporting an issue of an unmodified OSPOS installation
• [] Checked open and closed issues and no similar issue was already reported (please make sure you searched!)
• [] Read README, WHATS_NEW, INSTALL.md and UPGRADE
• [] Read the FAQ for any known install and/or upgrade gotchas (in specific PHP extensions installed)
• [] Read the wiki
• [] Executed any database upgrade scripts if an upgrade pre 3.0.0 (e.g. database/2.4_to_3.0.sql)
• [] Aware the installation code is in bintray (see README), and GitHub master is for developers only and therefore not complete nor stable

Installation information

• OSPOS version is:
• OSPOS git commit hash is:
• PHP version is:
• MySQL or MariaDB version is:
• OS and version is:
• WebServer is:
• Selected language is:
• (If applicable) Docker installation:
• (If applicable) Installation package for the LAMP/LEMP stack is:

Question

Hi!

My writing queries in sql but for some reason i cant get the transactions when searching for certain dates.

What format is required for this? Please advise.

[jekkos]

Just use 'yyy-mm-dd HH:mm:ss'