Re: [GENERAL] how to insert a date

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@shreve.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@shreve.net    | Shreveport, LA 71101 |
> http://www.shreve.net
>
--------------------------------------------------------------------
>
>

__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com