Java

if you want to add the current system time with your custom date , use the following sample to do it. you can also customize it your requirement accordingly.  select process_date,  to_date(to_char(process_date,'dd/mm/yyyy')||TO_CHAR(sysdate, 'HH:MI:SS'),'dd/mm/yyyy HH:MI:SS')  from T_BATCH_OPT where    schedule_id=3329 and rownum=1; SELECT to_date('10/12/2014'||TO_CHAR(sysdate, 'HH:MI:SS'),'dd/mm/yyyy HH:MI:SS')  FROM dual;

Sample Java prg using SQLite .. CURD operation.  Set up sqlite classpath  and path to ur machine accordingly.  /** * */ package sample; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.Statement; /** * @author PraveenKumar * */ public class SqlLite_CURD { /** * @param args */ public static void main(String[] args) { // TODO Auto-generated method stub //getConnection(); create(); populateData(); listAllValues(); } public static Connection getConnection(){ Connection connection=null; try{ Class.forName("org.sqlite.JDBC"); connection=DriverManager.getConnection(" jdbc:sqlite:D:/Praveen/sw/SQL_LITE/test.db "); //String sql="SELECT name FROM sqlite_master WHERE type='table' ;"; // String sql="SELECT * from test ;"; // PreparedStatement stmt=conn.prepareStatement(sql); // System.out.println(...

Roman number conversion from numeric to roman. The code seems  bigger but it is simple logic, if you want to try copy paste the code in the appropriate class name and execute the main class..... /**  *  */ package numbers; /**  * @author PraveenKumar  *  */ public class RomanConversionImpl implements IromanConversion{ public String convertRomanNumbers(int number) throws Exception { String romanNumber=""; boolean falg=new ISValidNumber().isValidNumber(number); if(!falg){ romanNumber=romanNumber+NumberRangeConversion.converNumber(number); }else{ throw new Exception("Invalid Number please validate your input!!!"); } NumberRangeConversion.reset(); return romanNumber; } } /**  *   */ package numbers; /**  * @author PraveenKumar  *   */ public class NumberRangeConversion { static String roman = ""; public static String conve...