Quick Links

Create Timestamp From Date and Time

From:	"Ron St(dot)Pierre" <rstpierre(at)syscor(dot)com>
To:	pgsql-general(at)postgresql(dot)org
Subject:	Create Timestamp From Date and Time
Date:	2002-11-22 20:08:59
Message-ID:	v9wD9.5759$ea.195066@news2.calgary.shaw.ca
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

Hi, I'm converting an Access db to Postgresql and want to convert a DATE
startDate and a TIME startTime column into asingle TIMESTAMP startTime
field.
The 7.2 documentation lists a function:
timestamp(date '1998-02-24',time '23:07')
to do just this, however when I try to run it without hard coding the
date and time fields it fails.

Can anyone enlighten me on what I'm doing wrong?

Thanks

BTW, this function is not listed in the 7.3rc2 documentation(?!)

--
Ron St.Pierre
Syscor R&D
tel: 250-361-1681
email: rstpierre(at)syscor(dot)com

Responses

Re: Create Timestamp From Date and Time at 2002-11-27 14:38:28 from Jean-Christian Imbeault
Re: Create Timestamp From Date and Time at 2002-11-27 16:24:14 from Ron St.Pierre
Re: Create Timestamp From Date and Time at 2002-11-27 16:32:36 from Tom Lane

Browse pgsql-general by date

	From	Date	Subject
Next Message	elein	2002-11-22 20:32:47	General Bits Weekly Column for pgsql-general
Previous Message	Felipe Schnack	2002-11-22 19:36:02	Re: EXECUTE problems