freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: CONVERT and MSSQL

From: "Winkless, Geoff" <geoff.winkless AT pera.com>
To: 'TDS Development Group' <freetds AT franklin.metalab.unc.edu>
Subject: Re: CONVERT and MSSQL
Date: Mon, 11 Mar 2002 16:38:17 -0000

Joshua Stein wrote:
> "... WHERE YEAR(column_name) = 2002 AND MONTH(column_name) = 3"

<aol>
Me too!!
</aol>

column_name BETWEEN '2002-03-01 00:00:00.000' AND '2002-03-31 23:59:59.999'

However the whole point was that although there may well be -better- ways of
checking a year/date combination, the LIKE '2001-03%' example shown -should-
work, and it'd be interesting to see why it doesn't.

Geoff

CONVERT and MSSQL, Mark, 03/11/2002
- <Possible follow-up(s)>
- RE: CONVERT and MSSQL, Matthews Simon, 03/11/2002
- Re: CONVERT and MSSQL, Kaeptn Weltall, 03/11/2002
- Re: CONVERT and MSSQL, Joshua Stein, 03/11/2002
- Re: CONVERT and MSSQL, mitch, 03/11/2002
- Re: CONVERT and MSSQL, Winkless, Geoff, 03/11/2002
- Re: CONVERT and MSSQL, Winkless, Geoff, 03/11/2002