A software package i want to use requires postgresql version 6.2.1
Therefor i compiled and installed it, everything works fine. I can
connect to the server via psql in xterm.
But the software claims, that there is no postgre server running.
My hd_dba.conf has the correct settings:
hosta
use the date_part function:
test=# select date_part('dow',current_timestamp);
date_part
---
4
(1 row)
or:
select date_part('dow',day) from schedule;
where 'dow' is the day of week.
see the user docs for other date/time functions
hth
tamsin
> -Original Message-
> Fr
i've created this table:
create table schedule (
day date,
tm timestamp,
room char(4));
insert into schedule values ('20/06/2001','08:00:00','A104');
my problem is how to get day of week information from date or is there any
way to do this?
would you show me how to do it?
thank's
Didi
Hi all,
Is there any good tutor on plpgsql language ?
With postgres docs there seems to be very little documentation
on plpgsql.
Thanks in advance.
--
Rajesh Fowkar
V. S. DEMPO & CO. LTD., PANAJI-GOA
Email ID : [EMAIL PROTECTED], [EMAIL PROTECTED]
Web Site : http://www.dempos.com
---
I am trying to create table with a field which type is timestamp
and I don't want it to be timestamp with time zone.
If I create the table with the following statement,
field type becomes timestamp with time zone:
CREATE TABLE "test" ("timest" timestamp DEFAULT now());
How can I make a field wh