---
title: "关于时间段的查询"
author: "xiajava2011"
date: "2011-06-29T19:10:15Z"
tags: []
categories: ["编程语言"]
slug: "untitled"
draft: false
lastmod: "2011-06-29T19:10:15Z"
id: 1109785
url: "https://xiajava2011.iteye.com/blog/1109785"
---

select * from 表名  where to\_char(日期字段,'YYYY-MM-DD HH24:MI')&gt;'2011-06-29 14:32' and to\_char(日期字段,'YYYY-MM-DD HH24:MI')&lt;'2011-07-16 14:20'