[SQL] EPOCH TIMESTAMP Conversion Problem

hi all, I have a table 'myTable'. There is an attribute in the table as, Column |Type | Modifiers -+-+--- mydate | timestamp without time zone | not null I want to convert MAX(mydate) from myTable to

Re: [SQL] EPOCH TIMESTAMP Conversion Problem

"Amitanand Chikorde" <[EMAIL PROTECTED]> writes: > I want to convert MAX(mydate) from myTable to Epoch. Do you mean SELECT EXTRACT(EPOCH FROM MAX(mydate)) FROM myTable regards, tom lane ---(end of broadcast)--- TIP 2

[SQL] Temporal databases

Hi, Does anyone have experience, tips, links, regarding how to build temporal databases with Postgresql? Thanks Philippe ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if y