package frame.persist;

import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;

public class DBDateTime {

	private static DataBaseType dbType;
	private Date date;
	
	public DBDateTime() {
		date = new Date();
	}
	
	public DBDateTime(Date date) {
		this.date = date;
	}
	
	public String toSQLString() throws Exception {
		String result = null;
		
		DateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
		String value = dateFormat.format(date);
		
		if (DataBaseType.Oracle == dbType) {
			result = "to_date('" + value + "','YYYY-MM-DD HH24:MI:SS')";
		}
		else if (DataBaseType.SQLServer == dbType) {
			result = "('" + value + "')";
		}
		else if (DataBaseType.MySQL == dbType) {
			result = "('" + value + "')";
		}
		else {
			throw new Exception("unknown database type");
		}
		
		return result;
	}
}