469,645 Members | 1,685 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,645 developers. It's quick & easy.

Migrating IBM Universe Database to Postgres, date format Problem

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
3 4547
michaelb
534 Expert 512MB
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
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
michaelb
534 Expert 512MB
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.

Similar topics

2 posts views Thread by Damon Greives | last post: by
9 posts views Thread by Coleen | last post: by
1 post views Thread by zsolt | last post: by
1 post views Thread by nagi28 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.