Postgres Pro
Downloads
Home   >   mailing lists

Create Timestamp From Date and Time - Mailing list pgsql-general

From Ron St.Pierre
Subject Create Timestamp From Date and Time
Date
Msg-id v9wD9.5759$ea.195066@news2.calgary.shaw.ca
Whole thread Raw
Responses Re: Create Timestamp From Date and Time  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Create Timestamp From Date and Time  ("Ron St.Pierre" <rstpierre@syscor.com>)
List pgsql-general
Tree view 
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@syscor.com

pgsql-general by date:

Previous
From: dave_h4@yahoo.com (Hunter)
Date:
Subject: escape single quote in INSERT command
Next
From: Hans-Jürgen Schönig
Date:
Subject: Re: Question about DEADLOCK