timestamp

From: David Eduardo Gomez Noguera <davidgn(at)servidor(dot)unam(dot)mx>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Cc: davidgn(at)servidor(dot)unam(dot)mx
Subject: timestamp
Date: 2001-11-12 13:10:45
Message-ID: 20011112071045.3d27ead3.davidgn@servidor.unam.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

hello.
i am doing some database, that will have a field indicating the time when that field was last modified, and want to compare it to a file's modification time.
what is the best way to do it? directly store the timestamp of the file as an integer? or turn the file timestamp into date, and then store it as date in the db? or is there a speciall field for that?

problem here is portability and easy.

thank you.

--
ICQ: 15605359 Bicho
=^..^=
First, they ignore you. Then they laugh at you. Then they fight you. Then you win. Mahatma Gandhi.
........Por que no pensaran los hombres como los animales? Pink Panther........
-------------------------------気検体の一致------------------------------------
暑さ寒さも彼岸まで。
アン アン アン とっても大好き

Responses

  • Re: timestamp at 2001-11-12 15:45:28 from David Eduardo Gomez Noguera

Browse pgsql-hackers by date

  From Date Subject
Next Message Bradley McLean 2001-11-12 14:10:36 Re: Possible major bug in PlPython (plus some other ideas)
Previous Message Zeugswetter Andreas SB SD 2001-11-12 10:18:43 Re: Triggered Data Change check