Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sybase conversion default on column GetDate()

561672Feb 15 2007 — edited Feb 19 2007

I am converting from Sybase to Oracle. Almost every table has a column with default of GetDate(). What do most people change this default to ?
If I am not mistaken I cannot use sysdate because it only goes to seconds. My other options I guess would be localtimestamp , systimestamp etc...
Also, can nls_date_format be set to see milliseconds ?
The application folks say they do need to keep the milliseconds.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 19 2007

Added on Feb 15 2007

#database-and-application-migrations

1 comment

1,353 views