Hi Anthony,

Depending on what the timestamps stand for :

20050120232143015Z or 20050203171600Z-0400

You chop off the Z for the first format and use the TO_TIMESTAMP function.
The FF part gives you the fractional seconds.
For the second format I'm not sure what the 0400 stands for. Is it 4
timezones earlier than the zulu timestamp ? If so you will have to
subtract 4 hours of the timestamp field.


create table tester (date2 timestamp);

DECLARE
date1 timestamp;

BEGIN
date1 := TO_TIMESTAMP('20050120:23:21:43:015',
'YYYYMMDD:HH24:MI:SS:FF3');

insert into tester values (date1);

END;


William Arcq / EDT
Tax and Reconciliation Systems
ext. 35477




-----------------------------------------
Visit us at http://www.clearstream.com
IMPORTANT MESSAGE Internet communications are not secure and therefore
Clearstream International does not accept legal responsibility for the
contents of this message. The information contained in this e-mail is
confidential and may be legally privileged. It is intended solely for the
addressee. If you are not the intended recipient, any disclosure, copying,
distribution or any action taken or omitted to be taken in reliance on it,
is prohibited and may be unlawful. Any views expressed in this e-mail are
those of the individual sender, except where the sender specifically states
them to be the views of Clearstream International or of any of its
affiliates or subsidiaries. END OF DISCLAIMER

Oracle LazyDBA home page