i have problem in datetime
my_table (start_date datetime,stop_date datetime);
insert into my_table values
('Sun May 13 16:19:27 2001 JAVT','Sun May 13 14:06:13 2001 JAVT')
select stop_date-start_date from my_table
the result is "@ 2 hours 13 mins 14 secs"
but i want result in minutes(integer) n
Hallo,
i have postgres 7.1 in Radhat 6.5
the Datestype default is ISO format
where is change default Datestyle to Postgres format ??
i used Set Datestyle to postgres in plsql
test#>select now()
now
2001-05-21 09:55:36+07
test#>set datestyle to postgres;
S
Hello,
i have an error
"psql: ERROR: MultiByte strings (MB) must be enabled to use this function"
where i must enable MultiByte strings (MB) ??
Nizomi
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriat
Hello,
i have an error :
NOTICE: get_groname: group 0 not found
getTables(): SELECT failed. Explanation from backend: 'pqReadData() --
backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
what ca
update t1
set amount = sum(b.amount)
from ts b
where a.id=b.id
On Thursday 18 January 2001 09:54, Carolyn Wong wrote:
> I'd like to know what's the correct SQL statement to do the following:
>
> updatet1 a
> set a.amount = sum(b.amount)
> from t2 b
> where a.id = b.id
i want to select date in january where day='Sunday'
any idea ??
please help me
Nizomi
i have file Dump > 500 MB
when i execute " gunzip -c data.dump.gz | psql internal "
some error message emerged as follows :
FATAL 1: copy: line 2516273, Memory exhausted in AllocSetAlloc()
what might be happen with the process ??
how to solve the problem ??
i use sparc sun solaris 2.6, postgre
Hallo,
i have table in postgres 7.0.2 migration from 6.5.3 using pg_upgrade
if i \d (table name) in psql ==> "Did not find any relation named"
How i describe table in postgres 7.0.2 ?
Thanks
Nizomi
hallo
help me please
how can i select maximal date in the month ??
as may = 31
june = 30
thanks
Nizomi
