how to cast localtimestamp to bigint??? - Mailing list pgsql-novice

From Pradeepkumar, Pyatalo (IE10)
Subject how to cast localtimestamp to bigint???
Date
Msg-id 77ED2BF75D59D1439F90412CC5B109741027FF0F@ie10-sahara.hiso.honeywell.com
Whole thread Raw
Responses Re: [SQL] how to cast localtimestamp to bigint???  (Edmund Bacon <ebacon@onesystem.com>)
Re: [SQL] how to cast localtimestamp to bigint???  (Guy Fraser <guy@incentre.net>)
Re: [SQL] how to cast localtimestamp to bigint???  (george young <gry@ll.mit.edu>)
List pgsql-novice
Hi,

I am having a table something like this....

CREATE TABLE(PointId integer, PointName varchar(50),PointType integer,
createtime bigint);

where createtime is the current timestamp when the tuple is inserted.

now how do I insert values into the above table. Is there a way to cast
timestamp to bigint.
Also can anyone suggest as to which date function to use -
CURRENT_TIMESTAMP, LOCALTIMESTAMP, timeofday(), now....


> With Best Regards
> Pradeep Kumar P J
>

pgsql-novice by date:

Previous
From: Raphael Bauduin
Date:
Subject: stress testing and performance monitoring
Next
From: Josh Berkus
Date:
Subject: Re: stress testing and performance monitoring