TO_CHAR or TO_DATE

From: Chairudin Sentosa <chairudin(at)prima(dot)net(dot)id>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: TO_CHAR or TO_DATE
Date: 1999-03-31 11:34:31
Message-ID: 37020847.8DBA2C2E@prima.net.id
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

Is the any similar function to 'to_char' and to_date' from Oracle in
Postgresql?

I have a problem insert only month-year.

create table blah
(id varchar(10),
month date,
week int4,
amount float8
);

insert into blah
(id, month, week, amount)
values
('1','MAR-1999',1,,3000);

I got error message : Bad date external representation MAR-1999

How to do it the right way to insert only month and year?

Regards,
Chai

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Chairudin Sentosa 1999-03-31 13:11:30 Re: [SQL] Odd "problem", not sure if there is a solution ....
Previous Message Marco.Iannacone 1999-03-31 08:44:59 merging date and time