|
Archives of the TeradataForumMessage Posted: Wed, 21 Nov 2007 @ 08:57:24 GMT
<-- Anonymously Posted: Tue, 20 Nov 2007 16:46 --> Hi All, Can anyone please tell me what is the difference between these two queries: sel * From test Where Exit_Date Between '0001-01-01' And '1900-01-01' sel * From test Where Exit_Date < '1900-01-01' And Exit_Date > '0001-01-01' First one returns me 35725730 records with Exit_Date as blank. Second one returns 4 rows with values 11/22/999 11/22/999 11/30/999 04/23/1199 Also sel * From Test Where Cast(Exit_Date As char) = '' Returns no value. Regards, Shubhangi
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||