From: | "Shridhar Daithankar<shridhar_daithankar(at)persistent(dot)co(dot)in>" <shridhar_daithankar(at)persistent(dot)co(dot)in> |
---|---|
To: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Fwd: Re: [GENERAL] Extracting time from timestamp |
Date: | 2003-03-21 06:45:13 |
Message-ID: | 200303211215.13495.shridhar_daithankar@persistent.co.in |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Friday 21 Mar 2003 11:38 am, Christopher Kings-Lynne wrote:
> > phd=# select time(abstime(timestamp 'now')) from bookings;
> > ERROR: parser: parse error at or near "abstime" at character 13
> > phd=# select time(timestamp 'now') from bookings;
> > ERROR: parser: parse error at or near "timestamp" at character 13
> > phd=# select version();
> > version
>
> Try:
>
> select "time"(abstime(timestamp 'now')) from bookings;
> select "time"(timestamp 'now') from bookings;
First of all, thanks, it worked..
And What's so holy about "" if it is a function?
That was bummer, I admit.. Spent almost a day on it..
Shridhar
P.S. Sorry, I didn't realized that I handn' CC hackers..
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2003-03-21 06:50:23 | Re: [GENERAL] Extracting time from timestamp |
Previous Message | Tom Lane | 2003-03-21 06:36:22 | Re: A bad behavior under autocommit off mode |