quem poder ajudar agradeço…
public Timestamp[] dataS(int codigo) throws ParseException{
Timestamp[] data = new Timestamp[2];
PreparedStatement consulta = null;
ResultSet rsConsulta = null;
Connection c = null;
try{
c = conexao.abrirConexao();
//horaInicio (apenas a hora ex: hh:mm:ss)
consulta = c.prepareStatement("select cast(dataInicio as time) from intervalo where codigo = "+codigo+"");
rsConsulta = consulta.executeQuery();
rsConsulta.next();
data[0] = rsConsulta.getTimestamp("cast(dataInicio as time)");
Timestamp horaInicio = data[0];
Time time = new Time(horaInicio.getTime());
//System.out.println("horaInicio: "+time);
//dataInicio (apenas a data ex: yyyy-MM-dd)
consulta = c.prepareStatement("select cast(dataInicio as date) from intervalo where codigo = "+codigo+"");
rsConsulta = consulta.executeQuery();
rsConsulta.next();
data[1] = rsConsulta.getTimestamp("cast(dataInicio as date)");
Timestamp dataInicio = data[1];
Date date = new Date(dataInicio.getTime());
String dInicio = date+" "+time;
SimpleDateFormat sdf = new SimpleDateFormat ("yyyy-MM-dd hh:mm:ss");
long a = sdf.parse(dInicio).getTime();
data[1] = new Timestamp(a);
//System.out.println("dataInicio: "+data[1]);
} catch(SQLException ex){
System.out.println(ex);
}
return data;
}
quando recebo data e hora da esse erro:
OBS: O objetivo consultar uma dataFim se estiver vazia daí chama dataS…
