Skip to Content.
Sympa Menu

freetds - Re: CONVERT and MSSQL

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Kaeptn Weltall" <rl AT w4u.com>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Re: CONVERT and MSSQL
  • Date: Mon, 11 Mar 2002 11:04:41 -0500


try

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

what will spare you dependence on stringoutput format
of datetime and good deal of processing time.




Archive powered by MHonArc 2.6.24.

Top of Page