freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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.
-
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
Archive powered by MHonArc 2.6.24.