By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,009 Members | 1,767 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,009 IT Pros & Developers. It's quick & easy.

Migrating IBM Universe Database to Postgres, date format Problem

P: 2
Hi I'm trying to migrate a universe database to postgres, so far I've exported the tables from universe using uvexport into a comma sep. text file. I've converted the file to CSV format and all's well apart from a table that contains dates.

Date fields in the exported file are shown as 5 digit numbers eg. 10655 which should = 3/3/97. Postgres doesn't recognise this format, or I'm not doin it right! , can enyone help me with this.
May 5 '07 #1
Share this Question
Share on Google+
3 Replies

Expert 100+
P: 534
I never worked with UniVerse, but I think your export utility dumps dates in internal format (I just don't know how else to explain 10655)

Some export utilities for PICK (isn't UniVerse a glorified PICK db?) allow you to specify the output format for date and time fields.
Can you check if uvexport has this option?
If it does, the best choice would be ISO 8601 - YYYY-MM-DD.
May 5 '07 #2

P: 2
Thanks for the reply, you were correct so for an easy life I just found out what the internal format is, It's the number of days from 31/12/1967, I've already had to do a reasonable amount of reformatting to the exported file so this extra is no prob.

Thanks for pointing me in the right direction.

Case Solved..............
May 6 '07 #3

Expert 100+
P: 534
Thanks for the update!

... the number of days from 31/12/1967 - well, what are you know!
And some people think that UNIX time (seconds since 1970-01-01) is weird enough.
May 6 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.