---
title: "取得某时间段的数据SQL语句"
author: "wtsoftware"
date: "2008-10-24T18:41:29Z"
tags: []
slug: "sql"
draft: false
lastmod: "2008-10-24T18:41:29Z"
id: 257688
url: "https://wtsoftware.iteye.com/blog/257688"
---

在SQLserver中可以利用getDate()来得到当前时间..从而判断是当前时间是否在某个范围内
select * from KM_notice where startTime<getDate() and closeTime>getDate();