Wednesday, January 4, 2012

SQL table statement help?

Since you did not supply a column-name list, it maps the values list in the same order you defined the columns. Your VALUES list has number-type values in quotes...strings should be quoted, not numeric values. You also don't convert your called or arrived dates to date-type via TO_DATE. Furthermore, you're trying to p a time (and just a time) to arrived and departed, which are date-types, not datetime-types.

0 comments:

Post a Comment