I set a timestamp type column in DS, and let DS create table in oracle.
Finally, DS create a date type column in oracle insead of timestamp , Anybody can help me in this problems.
Many Thanks
DS create Oracle table problems
Moderators: chulett, rschirm, roy
-
xinhuang66
- Participant
- Posts: 161
- Joined: Wed Aug 02, 2006 4:30 am
DATE stores time values in Oracle. Just use a to_char(yourcolumn, 'YYYY-MM-DD HH24:MI:SS') function to see this is true.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
The 'new' Oracle TIMESTAMP fields are not supported natively, and as you've found, are created as DATE fields instead. If you really want the field created as a flavor of TIMESTAMP, switch the table creation option to 'User Defined DDL' and make it create it however you want.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers