From: | Luis D(dot) García <ldgarc(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Make TIMESTAMP + TIME in the source code |
Date: | 2007-03-19 22:16:57 |
Message-ID: | 3de424340703191516sf4b8d4bo115df4b49fc2c101@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello, I'm writinng again because I need to make some validation for
the incoming data (VALUES... on the INSERT-Stmt). This validation
is based on adding a TIMESTAMP and a TIME kind of data.
From the Shell I can make:
template1=# select timestamp '02/03/85 7:00pm'+'00:00:02.3450' as
"TIMESTAMP+TIME";
And that would give me the next result:
TIMESTAMP+TIME
-------------------------
1985-02-03 19:00:02.345
That's exactly wath I need to do, obtain the result from adding a TIMESTAMP
and a TIME, but I must do it from the Postgre's source code, since I'm
working
on modifying Postgres for a University Project (here in Venezuela we call it
"Tesis" or "Graduation Special Work".
Due to this, I need to know if there's a special function on Postgre's
backend
code that can do this.
Greetings, I hope you could help me on this.
PD: in adition, both data (TIMESTAMP and TIME) are stored in strings (char
*).
The TIME is stored on the pg_class structure (thanks to a modification I
made),
and the TIMESTAMP is given on the INSERT values.
--
Luis D. García M.
Telf: (+58) 2418662663
Cel.: (+58) 4143482018
- FACYT - UC -
- Computación -
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-03-19 22:58:28 | Re: Buildfarm feature request: some way to track/classify failures |
Previous Message | Andrew Dunstan | 2007-03-19 21:27:47 | Re: Buildfarm feature request: some way to track/classify failures |