OracleDb.java 434 B

123456789101112131415161718
  1. package com.yihu.quota.util.sql;
  2. public class OracleDb implements Db {
  3. @Override
  4. public String getDate(String value) {
  5. return "to_date('" + value + "','YYYY-MM-DD')";
  6. }
  7. @Override
  8. public String getLongDate(String value) {
  9. return "to_date('" + value + "','YYYY-MM-DD HH24:MI:SS')";
  10. }
  11. @Override
  12. public String getNumber(String value) {
  13. return "to_number(" + value + ")";
  14. }
  15. }