Re: 7.2b Timestamp - Mailing list pgsql-general

From Thomas Lockhart
Subject Re: 7.2b Timestamp
Date
Msg-id 3BF2F936.E58C3118@fourpalms.org
Whole thread Raw
In response to 7.2b Timestamp  (Dave Smith <dave@candata.com>)
List pgsql-general
> This means you need to write
>         select "timestamp"(date '1998-02-24', time '23:07');

Less painful might be to use a different syntax:

  select (date '1998-02-24' + time '23:07');

should do what you need. Other places where you might be tempted to use
a function call to accomplish type conversion might be handled using the
CAST() function or operator.

                       - Thomas

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: 7.2b Timestamp
Next
From: "Thomas T. Thai"
Date:
Subject: gborg was Re: Sourceforge on Oracle?