INSERT a row with date fields

[thekobbler]

OK, this one should be easy (!)

I have a table:-

ARTICLE
---------------
title CHAR(256)
url   CHAR(256)
date  DATE

I can't seem to get PointBase to accept..

insert into ARTICLE (title,url,date) values ('an article title','article.pdf','2003-01-22')

I've tried various combinations, but usually get..

java.sql.SQLException: Illegal cast operation between type: CHARACTER and type: DATE.

returned. Any clues as to how to set a "DATE" field value

 

[swampBoogie]

According to the ANSI sql standard a date literal is specified as

insert into ARTICLE (title,url,date) values ('an article title','article.pdf',date '2003-01-22')

 

[thekobbler]

in the words of homer... doh!

 

[thekobbler]

IN the meantime; I did it this way.. which I think I prefer.

  String insertPrepStmt = "insert into ARTICLE (title,url,date) values (?,?,?)";
  java.sql.PreparedStatement prepStmt = conn.prepareStatement(insertPrepStmt);
  prepStmt.setString(1,title);
  prepStmt.setString(2,url);
  prepStmt.setDate(3,java.sql.Date(date.getTime()));
  prepStmt.execute();
  prepStmt.close();