`

where YEAR||'-'||MONTH||'-'||DAY >= '2008-10-10'

SQL 
阅读更多

抄的。

一张表里面有year,mouth,day(年,月,日)******等字段。但是对应的三个独立字段,应该算是varchar类型吧。
那怎么用一条SQL语句把具体某一天后的数据查出来呢,比如我要查询2008年10-10号后的全部数据,请问大家是怎么实现?

select * from TEST 
where YEAR||'-'||MONTH||'-'||DAY >= '2008-10-10'

分享到:
评论

相关推荐

    JSP万年历 JSP万年历

    charset=gb2312" language="java" import="java.sql.*" errorPage=""%> <%@page language="java" import="java.util.*"%> ...month=<%=month+1%>&year=<%=year%>'"> </td> </tr> </table> </body> </html>

    插入费用存储过程的实现方式

    --update bilvendjsm set yearmonth='2010-04' where yearmonth is null --select stdate,datediff(day,stdate,'2009.09.20') ,dateadd(day,20,stdate),dateadd(month,1,stdate),convert(varchar(7),dateadd(day,20...

    新版广州版小学英语六年级上册Unit7知识点及练习题精选.doc

    8. day -> days(天) 9. foot -> feet(脚) 10. book -> books(书) 11. dress -> dresses(连衣裙) 12. tooth -> teeth(牙齿) 13. sheep -> sheep(绵羊,单复同形) 14. box -> boxes(盒子) 15. ...

    Exchange 导出用户数据.docx

    Export-Mailbox -Identity <MailboxIdParameter> -StartDate "<Month/Day/Year>" -EndDate "<Month/Day/Year>" -PSTFolderPath <Path_Of_PST_Folder>\<File_Name>.pst ``` 这将根据指定的起始日期和结束日期导出...

    LINQ_to_SQL语法及实例大全.

    decimal averageOverTen = db.Products.Where(p => p.UnitPrice > 10).Average(p => p.UnitPrice); ``` ##### 4. Join - **一对多关系(1toMany)** ```csharp var query = from p in db.Products join s in ...

    新版pep小学六年级下册英语第三单元复习课件PPT学习教案.pptx

    - 表示过去发生的事情时,常用的时间状语有:`yesterday`, `last night`, `last Monday`, `last weekend`, `last year`, `last month`, `the day before yesterday`, `years ago`, `months ago`等。 3. **一般过去...

    mysql的日期和时间函数

     -> 728779mysql> SELECT TO_DAYS('1997-10-07'); -> 729669 TO_DAYS() 无意于使用先于格里高里历法(即现行的阳历)(1582)出现的值,因为它不考虑当历法改变时所遗失的天数。 FROM_DAYS(N) 给出一个...

    RTL8188C_8192C_USB_linux_v3.4.4_4749.20121105.zip

    10. install.sh Script to compile and install WiFi driver easily in PC-Linux ================================================================================================================== ...

    PHP(含mysql数据库)获取身份证信息,如身份证号码,获取性别、获取生日、计算年龄、获取地址、获取生肖、获取星座、以及判断是否是身份证号.rar

    '天秤座' => [9, 22], '天蝎座' => [10, 22], '射手座' => [11, 21] ]; foreach ($constellations as $name => $range) { if ($month > $range[0] && ($month $range[1] || ($month == $range[1] && $day >= $...

    Oracle PL/sql常用语句

    - `SELECT sysdate S1, round(sysdate) S2, round(sysdate, 'YEAR') YEAR, round(sysdate, 'MONTH') MONTH, round(sysdate, 'DAY') DAY FROM dual;` - **TRUNC**:截断到最接近的日期。 - `SELECT sysdate S1, ...

    一般过去时练习.docx

    3. Where did they go last year? 4. Did Tom watch TV last night? 5. Mary did her homework last night. 五、选择填空: 1. D. left 2. B. Did, have 3. C. arrived, wrote 在使用一般过去时时,需要注意以下几...

    23个Mysql常用语句查询 最新 最全

    - **示例**:`SELECT * FROM tb_name WHERE sum > 100;` - 这里使用了比较运算符 `>` 来筛选 `sum` 字段大于100的所有记录。 - **其他常用比较运算符**: - `=`:等于 - `小于 - `<>` 或 `!=`:不等于 - `!>`:...

    动易博客日历插件(20081212)

    <div id=blog_title><A href="{$InstallDir}{$Field(0,GetUrl,Article,1)}" target=_blank>{$Field(1,Text,60,2,1)}</A> {$Field(4,Time,0,{year}年{month}月{day}日)} </div></td> </tr> </table> <table style...

    oracle触发器实现

    (id, train_id, year, month, month_move, month_correct_move, after_make_move, train_type, train_no) VALUES (:new.id, :new.train_id, :new.year, :new.month, :new.month_move, :new.month_move, :new....

    SQL sever 实训

    PRINT @ProNo+' '+@ProName+' '+STR(YEAR(@SaleDate))+'-'+STR(MONTH(@SaleDate)) +'-'+STR(DAY(@SaleDate))+' '+@Quantity+' '+@SM+' ' FETCH NEXT FROM CRS INTO @ProNo,@ProName , @SaleDate,@Quantity , @SM ...

    山东省诸城市密州街道卢山初中2016届中考英语专题复习一般过去时测试题

    3. Where did they go last year? 4. Did Tom watch TV last night? 5. Mary did her homework last night. **五、选择填空** 1. D. left 2. B. Did, have 3. C. arrived, began 这些练习题旨在帮助学生掌握一般...

    php选择日期

    if (checkdate($month, $day, $year)) { echo '日期有效'; } else { echo '日期无效'; } ``` 6. **与MySQL交互** 在存储或检索日期时,可能需要与MySQL数据库交互。PHP的PDO扩展提供了一种安全的方法来绑定参数,...

    T-SQL高级查询

    select count(*), (sex * id) new from student where id > 2 group by sex * id order by sex * id; --group by all 所有分组 按照年龄分组,是所有的年龄 select count(*), age from student group by all age; ...

    Hive 基本命令操作1

    ble employee(id int, name string, join_date date) partitioned by (year int, month int, day int); 在Hive中,分区表是一种优化数据查询的方法,它将大表的数据按照特定的逻辑划分成多个小的、独立的部分,每个...

    oracle函数

    SELECT sysdate S1, TRUNC(sysdate) S2, TRUNC(sysdate, 'YEAR') YEAR, TRUNC(sysdate, 'MONTH') MONTH, TRUNC(sysdate, 'DAY') DAY FROM dual; ``` - **GREATEST**: 返回日期列表中最晚的日期。 ```sql SELECT...

Global site tag (gtag.js) - Google Analytics