ORM Bee,如何使用Oracle的TO_DATE函数?
ORM Bee,如何使用Oracle的TO_DATE函数?
在Bee V2.4.0,可以这样使用:
LocaldatetimeTable selectBean=new LocaldatetimeTable();
Condition condition=BF.getCondition();
condition.op("localdatetime", Op.ge, new TO_DATE("2024-07-08", "YYYY-MM-DD"));
List<LocaldatetimeTable> list=suidRich.select(selectBean,condition);
Printer.printList(list);
日志:
[INFO] [Bee] -------- Bee 2.4.0 --------
[INFO] [Bee] -------- Honey 2.4.0 --------
[INFO] [Bee] -------- BeeExt 2.4.0 --------
[DEBUG] [Bee] ========= Bee buildId 2.4.0.7
[DEBUG] [Bee] ========= Honey buildId 2.4.0.7
[DEBUG] [Bee] ========= BeeExt buildId 2.4.0.7
[INFO] [Bee] ========= get the dbName via url is: Oracle
[INFO] [Bee] select SQL: select id,name,datetime,timestamp,localdatetime,ext,json from localdatetime_table where localdatetime>=TO_DATE(?, 'YYYY-MM-DD') [values]: 2024-07-08(String)
[INFO] [Bee] select SQL: ( ExecutableSql )
select id,name,datetime,timestamp,localdatetime,ext,json from localdatetime_table where localdatetime>=TO_DATE('2024-07-08', 'YYYY-MM-DD') ;
[DEBUG] Use OriginalConn!
[INFO] [Bee] | <-- select rows: 2
[INFO] LocaldatetimeTable[id=12,name=null,datetime=null,timestamp=null,localdatetime=2024-07-08T23:55:35.534,ext=null,json=null]
[INFO] LocaldatetimeTable[id=13,name=null,datetime=null,timestamp=null,localdatetime=2024-07-08T23:56:01.521,ext=null,json=null]
condition.op("localdatetime", Op.ge, new TO_DATE("2024-07-08", "YYYY-MM-DD"));
对应SQL:
//where localdatetime>=TO_DATE('2024-07-08', 'YYYY-MM-DD') ;
原文地址:https://blog.csdn.net/abckingaa/article/details/140337682
免责声明:本站文章内容转载自网络资源,如本站内容侵犯了原著者的合法权益,可联系本站删除。更多内容请关注自学内容网(zxcms.com)!