选择具有日期条件的查询 [英] Select query with date condition

问题描述

我想在 d / mm / yyyy 之后或在 d / mm / yyyy 在 d / mm / yyyy 之前，我该怎么做？

I would like to retrieve the records in certain dates after d/mm/yyyy, or after d/mm/yyyy and before d/mm/yyyy, how can I do it ?

SELECT date
FROM table
WHERE date > 1/09/2008;

和

SELECT date
FROM table
WHERE date > 1/09/2008;
AND date < 1/09/2010

它不起作用。

推荐答案

小心，你不知不觉地问日期大于1，除以九，除以二千和八。

Be careful, you're unwittingly asking "where the date is greater than one divided by nine, divided by two thousand and eight".

在日期左边的＃标志，像这样＃1/09/2008＃

Put # signs around the date, like this #1/09/2008#

这篇关于选择具有日期条件的查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！