Re: question on date (or string after using convert function) comparis
- From: Hugo Kornelis <hugo@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 14 Feb 2006 22:56:40 +0100
On Mon, 13 Feb 2006 19:05:26 -0800, kei wrote:
select case when '02/12/2005' >= '01/02/2006' then 'T' else 'F' end
the result return is 'T' why?? (2005 should be < 2006)
Hi kei,
You are comparing two string constants. They may look like dates to you
and me (though probably not the same dates - I'm from the part of the
world that uses dd/mm/yyyy), but SQL Server doesn't try to interpret
what you write - it takes you literally.
You could try
SELECT CASE WHEN CAST('02/12/2005' AS datetime) >=
CAST('01/02/2006' AS datetime) THEN 'T' ELSE 'F' END
and pray that SQL Server interprets the ambiguous date format the same
way you do.
Or you could switch to a non-ambiguous date format:
SELECT CASE WHEN CAST('20051202' AS datetime) >=
CAST('20060201' AS datetime) THEN 'T' ELSE 'F' END
For more information, check Tibor Karaszi's article on SQL Server date
and time handling: http://www.karaszi.com/SQLServer/info_datetime.asp
--
Hugo Kornelis, SQL Server MVP
.
- Prev by Date: Re: select field contain chr(10) (Line Feed character) usng T-SQL
- Next by Date: Re: SELECT ~~ OVER(PARTITION BY ~~) in SQL Server 2005?
- Previous by thread: Re: select field contain chr(10) (Line Feed character) usng T-SQL
- Next by thread: Re: SELECT ~~ OVER(PARTITION BY ~~) in SQL Server 2005?
- Index(es):
Relevant Pages
|
|
