Re: Build Timestamp?

[Francis Lapeyre <flapeyre@xxxxxxxxxxxxxx>]

Kahn, David wrote:
> 
> Booth Martin (boothm@ibm.net) wrote:
> 
> >
I'm looking to build a Timestamp TYPE field.  Using the Timestamp
> >
datatype.
> >
> >I'm missing something then.
> >Why not use a Z field type in the first place?  and then:
> >
> >    C             TIME             ZFIELD
> >
> >where ZFIELD is described in the DDS spec as a Z type?
> 
> The TIME opcode requires a numeric result field. Crazy though it
> sounds
> you cannot TIME straight into a timestamp field.
> 
> Dave Kahn - TCO, Tengiz, Kazakstan
> =========
> 
> e-mail:  kahn@tengizchevroil.com    (until September 30th)
>          dkahn@cix.compulink.co.uk  (from  October 1st)

TIME to a timestamp field works, all right, but only if you have V3R7.

-- 
    Francis Lapeyre                       flapeyre@communique.net
    ____________________________________________________________
   |                                                            |
   |"The probability of life originating from accident is       |
   |comparable to the probability of the Unabridged Dictionary  |
   |resulting from an explosion in a printing factory."         |
   |                                                            |
   | --Prof. Edwin Conklin                                      |
   |____________________________________________________________|

****** Unsolicited commercial e-mail is not tolerated here. *******
****** Senders of such mail do so at their own peril.       *******
****** A copy, complete with header, is forwaded to the     *******
****** originating ISP for action.                          *******

      Opinions are my own. Otherwise, they are someone else's.
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MAJORDOMO@midrange.com
|    and specify 'unsubscribe MIDRANGE-L' in the body of your message.
| Questions should be directed to the list owner/operator: david@midrange.com
+---