Recent content by Randy Shafer

thanks! that worked! since i have made that change my "oracle SQL worksheet" that i use sometimes gives me this error when I try to select the table: SQLWKS> select * from diebold.local_crosswalk; ORA-03115: unsupported network datatype or representation this is not a real problem, but i would...

This is the command and result (you asked for): SQL> select dbtimezone,sessiontimezone from dual [Oracle][ODBC][Ora]ORA-00942: table or view does not exist My ONLY options to define the column type(from the drop down box) are: number varchar2()...

More explanation: I have created a table and one of the columns is set to the following default value, in order to automatically timestamp when a record is posted in my table: current_timestamp (3) at local AS i said before the time is wrong in the timestamp, as in the example in my previous...

when I set the default for my timestamp column to: current_timestamp(3)at local I get the following for a timestamp: 30-MAR-04 10.39.05.632 PM +00:00 This was yesterday at 04.39.05.632 PM when I issued an insert into the table. why is the time wrong?

Iam using a default value of : current_timestamp at local for a field in a table. It works, but displays the Greenwich Time (6 hours earlier). How would I write the above default statement in my PL/SQL Developer table to give me Central Standard Time? I have tried everything from the manuals...