Hi all, We are in the process of migrating our Dspace 1.4.2 instance that is running on Postgresql to an Oracle database. One of the (many) issues we encounter is the TIMESTAMP. Several tables contain a field of type TIMESTAMP. In the Postgresql database_schema.sql the type TIMESTAMP is used for most tables, except table ITEM which uses a TIMESTAMP WITH TIMEZONE. The Oracle version of database_schema.sql uses the TIMESTAMP type for all tables. However, the dates exported by Postgresql all are in the form of 2008-02-14 14:23:29.894. Oracle does not recognise this as a valid timestamp.
Is it save to convert these timestamps all to a regular date, or is the timezone required? If so, how can we import these into Oracle? Best wishes, Francis Brouns ------------------------------------------------------------------------------ Throughout its 18-year history, RSA Conference consistently attracts the world's best and brightest in the field, creating opportunities for Conference attendees to learn about information security's most important issues through interactions with peers, luminaries and emerging and established companies. http://p.sf.net/sfu/rsaconf-dev2dev _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
