[GENERAL] Problems with date configuration

2006-09-13 Thread Fabi Avilés
Hi, I had an application in which I used postgres 7.4, and then only thing refering to date was: datestyle = 'ISO,European'everything else was commented. Now I have had to change the OS and I've installed postgres 8.1.3, but this configuration is different, it's something like:        lc_monet

[GENERAL] Date using Int8

2006-09-06 Thread Fabi Avilés
Hi people. I'm trying to understand the DB model of an application, and I´ve found that the sava dates using Int8 type. I need to know how can I convert it to a date format or something taht I can understand as a date. Thanks.