freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: CONVERT and MSSQL

From: Joshua Stein <jcs AT rt.fm>
To: TDS Development Group <freetds AT franklin.oit.unc.edu>
Subject: Re: CONVERT and MSSQL
Date: Mon, 11 Mar 2002 10:22:56 -0600

> select * from table_name
> where datepart(yyyy,column_name) = 2002
> and datepart(mm,column_name) = 3

Or just:

"... WHERE YEAR(column_name) = 2002 AND MONTH(column_name) = 3"

-j.

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