If you have a database of books in the library and you would like to find all books published after January 1, 2008, what criteria would you enter? < > January 1, 2008 > January 1, 2008 is January 1, 2008 < January 1, 2008

Respuesta :

To find all books published after January we should follow > January 1, 2008

Explanation:

In the case of a database, in which we want to find all the books published after January 1, 2008, the required query should consist of the expression > January 1, 2008.

Although generally, while executing a query that deals with a date, the date should be in coherence with the specified format. The format to be used is defined while entering data in a table.

The most preferable and used format for dealing with dates is yyyy-mm-dd. Although the selection of the format to be used always depends on the user and may vary accordingly.