如何在SQL中搜索包含冒号的字符串？(How can i search for a string in SQL which contains a colon?)

 有没有办法在SQL中搜索包含冒号的字符串？ 
 
 例： 
 
 我在数据库中有像2009-09-17 05:00:00.000和2011-11-10 06:00:00.000的值。 但是我想要所有具有05:的值。 
 
 我尝试了以下SQL，但它给了我一个空白的结果： 
 
SELECT cast(narrative_date as datetime)
FROM P_MATTER_NARRATIVE
WHERE cast(narrative_date as datetime)
LIKE '%05:%';
 
 谢谢Rajan 

Is there a way I can search for a string in SQL which contains a colon?
 
Example:
 
I have values like 2009-09-17 05:00:00.000 and 2011-11-10 06:00:00.000 in the database. But I want all the values which have 05: in them.
 
I tried the following SQL, but it gives me a blank result:
 
SELECT cast(narrative_date as datetime)
FROM P_MATTER_NARRATIVE
WHERE cast(narrative_date as datetime)
LIKE '%05:%';
 
Thanks Rajan

原文：https://stackoverflow.com/questions/31238938