Re: [GENERAL] Default 'timestamp' value on HP-UX running Postgresql6.3.2 - Mailing list pgsql-general

Hello Sangeeta,

martedì, 29 settembre 98, you wrote:

SR> I am running postgres 6.3.2 on HP_UX 10.2. I have a field defined as
SR> type 'timestamp' and am using ISO datestyle. The default value shows
SR> up as the string constant 'epoch'. Is there any way of having the numeric
SR> value of '1970-01-01 00:00:00+00'  returned instead??

SR> I appreciate any help! Thanks.
SR> -sr

I don't know if there's a more intelligent way to solve this problem
but I had the same problem and I solve this by my self by modifying
the file: postgresql-6.3.2/src/backend/utils/adt/timestamp.c and
re-install PostgreSQL.

.....
     29         char            zone[MAXDATELEN + 1],
     30                            *tzn = zone;
     31
     32         switch (timestamp)
     33         {
     34 /*remark the following 3 lines to have dates as '1970-01-01 00:00:00+00' instead of 'epoch'
     35                 case EPOCH_ABSTIME:
     36                         strcpy(buf, EPOCH);
     37                         break;
     38 */
     39                 case INVALID_ABSTIME:
     40                         strcpy(buf, INVALID);
.....

I hope this help you
      Jose'