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

And that would give me the next result:

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
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
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
and the TIMESTAMP is given on the INSERT values.
Luis D. García M.

Telf: (+58) 2418662663
Cel.: (+58) 4143482018

- FACYT - UC -
- Computación -

Reply via email to