mysql查询检查日期包含19 / [英] Mysql query to check the date contains19/
问题描述
显示包含19 /的日期栏
查询
SELECT用户名,DATE_FORMAT (dialdate,GET_FORMAT(DATE,'EUR'))作为新的,DATE_FORMAT(拨号时间,'%r')作为拨号时间,价格FROM processeddata_table WHERE DialDate在'2008/07/04'和'2013/07/26'之间拨号日期比如'%19 /%00:00:00'
你的,你的问题是什么?
SELECT 用户名,DATE_FORMAT(dialdate,GET_FORMAT( DATE ,< span class =code-string>' EUR')) as new,DATE_FORMAT (dialtime,' %r') as dialtime,price FROM processeddata_table WHERE DialDate <水疗中心n class =code-string>' 2008/07/04' 和 < span class =code-string>' 2013/07/26' 和 dialdate 喜欢 ' %19% '
简单;)
使用 LEFT [ ^ ]功能。
SELECT ...
FROM ....
WHERE ... LEFT (dialdate, 2 )= ' 19'
有关字符串函数 [ ^ ]
注意:此陈述是否为真:(年> = 2008年和< = 2013)AND(年> = 1900 AND年< = 1999)
To display the date column containing "19/"
Query
SELECT username,DATE_FORMAT(dialdate,GET_FORMAT(DATE,'EUR')) as new,DATE_FORMAT(dialtime,'%r') as dialtime,price FROM processeddata_table WHERE DialDate between '2008/07/04' and '2013/07/26' and dialdate like '%19/% 00:00:00'
ur,what is your problem ?
SELECT username,DATE_FORMAT(dialdate,GET_FORMAT(DATE,'EUR')) as new,DATE_FORMAT(dialtime,'%r') as dialtime,price FROM processeddata_table WHERE DialDate between '2008/07/04' and '2013/07/26' and dialdate like '%19%'
Simply ;)
Use LEFT[^] function.
SELECT ... FROM .... WHERE ... LEFT(dialdate,2) = '19'
More about String functions[^]
Note: Is this statement true:(year>=2008 And year <=2013) AND (year>=1900 AND year<=1999)
?
这篇关于mysql查询检查日期包含19 /的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!