Guest User

Untitled

a guest
Apr 25th, 2018
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.34 KB | None | 0 0
  1. java.sql.Date sqlDate = null;
  2. java.util.Date utilDate = new Date();
  3. sqlDate = new java.sql.Date(utilDate.getTime());
  4. PreparedStatement psmtInsert = conn.prepareStatement(insertQuery);
  5. psmtInsert.setDate(1, sqlDate));
  6. psmtInsert.executeUpdate();
  7.  
  8. PreparedStatement psmtSelect = conn.prepareStatement("select dateOfJoining from EMPLOYEE");
  9. ResultSet resultSet = psmtSelect.executeQuery();
  10. while (resultSet.next()) {
  11. System.out.println(resultSet.getDate(1));
  12. }
  13.  
  14. java.sql.Date sqlDate = null;
  15. java.util.Date utilDate = new Date("1397/02/04");
  16. sqlDate = new java.sql.Date(utilDate.getTime());
  17. PreparedStatement psmtInsert = conn.prepareStatement(insertQuery);
  18. psmtInsert.setDate(1, sqlDate));
  19. psmtInsert.executeUpdate();
  20.  
  21. SELECT TO_DATE(
  22. '1397/02/05',
  23. 'yyyy/mm/dd',
  24. 'nls_calendar=persian'
  25. )
  26. FROM DUAL
  27.  
  28. | TO_DATE('1397/02/05','YYYY/MM/DD','NLS_CALENDAR=PERSIAN') |
  29. |-----------------------------------------------------------|
  30. | 2018-04-25T00:00:00Z |
  31.  
  32. SELECT TO_CHAR(
  33. DATE '2018-04-25',
  34. 'yyyy/mm/dd',
  35. 'nls_calendar=persian'
  36. )
  37. FROM DUAL
  38.  
  39. | TO_CHAR(DATE'2018-04-25','YYYY/MM/DD','NLS_CALENDAR=PERSIAN') |
  40. |---------------------------------------------------------------|
  41. | 1397/02/05 |
Add Comment
Please, Sign In to add comment