t 11:59 PM, Cefull Lo wrote:
> Hi everybody,
> I'm located in Hong Kong, UTC+8 time zone. When I
>
> select current_timestamp;
>
> gives
>
> now
> ---
> 2012-01-13 23:56:16.825558+08
>
> However, when I
>
> sele
Hi everybody,
I'm located in Hong Kong, UTC+8 time zone. When I
select current_timestamp;
gives
now
---
2012-01-13 23:56:16.825558+08
However, when I
select current_timestamp at time zone 'UTC+8';
I expect the result is the same as the above one. But
I just installed phpPgAdmin-4.1.3, when I try to
login, it always tell me login fail.
I followed the steps in FAQ but still can't login.
I'm sure that postgresql is running and accepting
tcpip connection (psql -h 192.168.4.4 mydb from other
machine is OK), and password is correct.
I'm using
pos
Is there any function to count the number of query run
in one sentence?
i.e.
select * from mytable;
return 1
select * from mytable;select * from mytable2;
return 2
-BEGIN GEEK CODE BLOCK-
Version: 3.12
GSC d- s:>++ a- C++ UL/B+++$ !P L++>+
E--- W+ N o-- K? w++ O? M- V- PS PE++(-) Y+
given a timestamp data, e.g. 2001-08-18 06:01:23+08
How can I check that is it lie between 00:00:00 and 08:00:00 and ignore the
date?
--
content-type:kiss/hug
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgre
When I type INSERT INTO friend
VALUES ('', '', '');
it returns
INSERT 19748 1
what means of 19748 and 1?
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to
