Problem checking day of week from date

i'm trying to find out the day of the week from a date stored in a database.

i am using smallsql for my database.

s.executeQuery("select * from results");

ResultSet result=s.getResultSet();

result.next();

day=result.getString(1);

System.out.println(day);

sql="select dayofweek({d "+day+"}) from results";

this is the code to read in the date and set up the sql

and this is the code to get the number representing the day of the week

s.executeQuery(sql);

ResultSet result=s.getResultSet();

result.next();

daynum=result.getInt(1);

System.out.println(daynum);

[649 byte] By [alancola] at [2007-11-27 4:47:03]