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 > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster