Re: UNIX timestamps

#1

On Wed, 2004-07-28 at 17:38, Eduardo VÃ¡zquez RodrÃ*guez wrote:

Quote:

Hi everyone out there using Postgres

Is there a data type or function in Postgres to handle UNIX
timestamps?

I have to handle datea in unix timestamp format like this
1079092862.453 and I would like to be inserted in human readable way

Any suggestions are welcome

Do you need speed or precision?

For max speed, use an int4 and drop the non-integer part.

For good speed, use floats. They're pretty close and fair to middling
on performance.

For best precision, but slowest speeds, use numeric(18,3) or something
like that. Whatever the maximum size you have to deal with.

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: UNIX timestamps

comp.databases.postgresql.novice comp.databases.postgresql.novice

Re: UNIX timestamps - 07-29-2004 , 02:28 AM