From: | "Ron St(dot)Pierre" <rstpierre(at)syscor(dot)com> |
---|---|
To: | Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Create Timestamp From Date and Time |
Date: | 2002-11-27 16:24:14 |
Message-ID: | 3DE4F1AE.8050008@syscor.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Example - when I run the following:
select timestamp(date '1998-02-24',time '23:07')
I get the following error:
parse error at or near "date"
I am migrating a DB from Access to postgreSQL and want to convert two
fields from one table into one field (dtmStartDate + dtmStartTime into
startTimestamp). I am running a script after migrating to make many
other changes as well. However, I thought I would try the timestamp
function with the data and time "hard coded" just to see if my use of
the function was correct.
Jean-Christian Imbeault wrote:
> > 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 you givean example of the statement you use when "not hard coding"?
>
> Jc
--
Ron St.Pierre
Syscor R&D
tel: 250-361-1681
email: rstpierre(at)syscor(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-11-27 16:28:00 | Re: postgresql slow down |
Previous Message | Tom Lane | 2002-11-27 16:18:57 | Re: Server v7.3RC2 Dies |