Skip to Content.
Sympa Menu

freetds - Re: CONVERT and MSSQL

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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




Archive powered by MHonArc 2.6.24.

Top of Page