30')) is 1310677200
As you understand, I always get all records ...
How do I solve it?
Thanks,
Janiv.
Best regards,
Janiv Ratson
Software Architect & Team Leader
Essence Home & Family LTD.. (Part of Essence Group)
Tel: +972-73-2447779 | Fax: +972-9-9564182 | Mobile
t: Sunday, August 14, 2011 20:57
To: pgsql-sql@postgresql.org
Cc: Janiv Ratson
Subject: Re: [SQL] bigint and unix time
On Sunday, August 14, 2011 4:13:30 am Janiv Ratson wrote:
> Hi,
>
>
>
> I have the following query:
>
>
>
> select ticket as ticket, time as created
Hi Adrain and thank you,
Trac 0.12 uses microseconds as time value.
What do you suggest?
Thanks,
Janiv.
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Monday, August 15, 2011 17:14
To: Janiv Ratson
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] bigint and
;)) AND
extract(epoch from (date 'now'));
Thanks a lot again,
Janiv.
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Monday, August 15, 2011 17:14
To: Janiv Ratson
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] bigint and unix time
On Sund
061500;131085;1313442000
Thanks,
Janiv,
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@gmail.com]
Sent: Monday, August 15, 2011 17:14
To: Janiv Ratson
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] bigint and unix time
On Sunday, August 14, 2011 11:23:08 pm Janiv Rats
