why can I insert date into Oracle database date column

[omerdurdu]

Oracle database I have a table and a field called Date and type is date. When I try to insert date in it it says invalid user.table column, table column or column specification; Here is the code:

insert into parkcode_xref(date)
values ('#CrateODBCTime(Now())#')

Thanks for help

 

[csteinhilber]

It's been a while... but I believe this is correct;

The date type is not a string... so you shouldn't be including it in quotes in the INSERT.

ie -

insert into parkcode_xref(date)
values (#CreateODBCTime(Now())#)

Hope it helps,
-Carl

 

[r937]

It's probably because you have "a field called Date"

i can't remember offhand how oracle lets you get around this

in microsoft access it would be square brackets, but try putting it in doublequotes, e.g.

insert into parkcode_xref("date&quot

better yet, redefine the column name


rudy

 

[BaconMakinWabbit]

You definately have to redefine the columnname. There isn't a workaround for the date reserved word(s) in Oracle.