Re: 7.2b Timestamp

From: Thomas Lockhart <lockhart(at)fourpalms(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Dave Smith <dave(at)candata(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: 7.2b Timestamp
Date: 2001-11-14 23:07:34
Message-ID: 3BF2F936.E58C3118@fourpalms.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas T. Thai 2001-11-14 23:18:16 gborg was Re: Sourceforge on Oracle?
Previous Message Svenne Krap 2001-11-14 22:40:16 Userauth and hosting