Skip to Content.
Sympa Menu

freetds - Re: CONVERT and MSSQL

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

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




Archive powered by MHonArc 2.6.24.

Top of Page