import java.io.BufferedReader;
import java.io.File;
import java.io.FileReader;
import java.io.IOException;
public class ToChange {
/**
* @Method : main
* @Written by : zhangjun
* @Creation Date : Jan 12, 2012 - 8:29:45 AM
* @Description :
* @return : void
* @throws IOException
*/
public static void main(String[] args) throws IOException {
File file=new File("D:/a.txt");
if(!file.exists()){
file.createNewFile();
}
FileReader fr=new FileReader(file);
BufferedReader br=new BufferedReader(fr);
String temp="";
String line=null;
while((line=br.readLine())!=null){
temp+=line;
String temp1=temp.substring(0, temp.length()-23);
int total = temp.length();
int sa = temp.length()-23;
System.out.println(temp1 + " \"TO_DATE\"("+temp.substring(sa,sa+20) +"', 'YYYY-MM-DD HH24:MI:SS'));");
temp="";
temp1="";
}
br.close();
fr.close();
}
}