From: | soundar rajan <psrajan(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: [GENERAL] how to insert a date |
Date: | 1999-10-15 18:25:16 |
Message-ID: | 19991015182516.24112.rocketmail@web2101.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks.
1. But, How to get use the general functions like
char_length( ....); Like in Oracle, we've select
(5*6) from dual; What is the substitute for the dual
in pg DB.
2. Is it true that 6.5.2 doesn't support foreign keys.
This is what my qn. really was. Sorry, had I written
the last qn. so as to be interpreted the way you
meant it.
Thanks.
Soundar.
--- Kevin Heflin <kheflin(at)shreve(dot)net> wrote:
> On Fri, 15 Oct 1999, soundar rajan wrote:
>
> > hi,
> > Can anyone help me -- how to insert a date value
> into
> > a postgresql db
>
>
> assuming the data type is of the 'date' type
>
>
> insert into tablename (datefield) values
> ('11/31/1999');
>
>
> or
>
> insert into tablename (datefield) values
> ('current_date');
>
>
>
> something like that.
>
>
>
>
>
> >
> > Thanks in advance.
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Bid and sell for free at http://auctions.yahoo.com
> >
> > ************
> >
>
>
--------------------------------------------------------------------
> Kevin Heflin | ShreveNet, Inc. |
> Ph:318.222.2638 x103
> VP/Production | 333 Texas St #175 |
> FAX:318.221.6612
> kheflin(at)shreve(dot)net | Shreveport, LA 71101 |
> http://www.shreve.net
>
--------------------------------------------------------------------
>
>
__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Aaron J. Seigo | 1999-10-15 18:58:15 | Re: [GENERAL] User defined function |
Previous Message | soundar rajan | 1999-10-15 18:05:15 | how to insert a date |