Oracle sqlÓï¾äת»»ÎªMysqlÓï¾ä ¼±~~

Oracle £ºselect grbh from com.eway.vo.Zjxx zj where to_char(zj.jbsj,'yyyymm')='"+ sj + "'
ÆäÖÐ sjÊÇ×Ö·û´®²ÎÊý  ÏÖÔÚÏë°ÑÉÏÃæµÄSQLÓï¾äת»»ÎªMysqlµÄ  Ö÷ÒªÊÇʱ¼ä´«Èë  ÒòΪ´«ÈëµÄÊÇ×Ö·û´®  200909  ¶øÊý¾Ý¿âÖÐÊÇ  2009-09-31 00£º00£º00  ËùÒÔÏëÇë½ÌÈçÉÏÔÚMysqlÈçºÎÐÞ¸Ä~
ÔÚÏߵȠ ¼±~~

---

DATE_FORMAT(zj.jbsj,'%Y%m')

---

SQL code:
mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2009-09-09 16:08:42 |
+---------------------+
1 row in set (0.00 sec)

mysql> select date_format(now(),'%Y%m');
+---------------------------+
| date_format(now(),'%Y%m') |
+---------------------------+
| 200909 |
+---------------------------+
1 row in set (0.00 sec)

mysql>

---

ÍêÈ«µÈ¼ÛµÄд·¨ date_format º¯Êý µÈ¼ÛÓÚ to_char£¬src_TO_DATEº¯ÊýµÈ¼ÛÓÚ to_date

select grbh from zj where date_format(zj.jbsj,'%Y%m')='"+ sj + "'

---

ssql = "select grbh from com.eway.vo.Zjxx zj where date_format(zj.jbsj,'%Y%m')='"+ sj + "'"

---

SELECT GRBH from FFXX WHERE FFSJ=to_date('"ffsj"','yyyy-mm-dd')";

Õâ¸ö¸ÃÔõô¸ÄÄØ£¿£¿Ð»Ð»ÁË

---

SQL code

---

Code highlighting produced by Actip