Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to convert an UTC timestring to oracle's TIMESTAMP(6) type?

How to convert an UTC timestring to oracle's TIMESTAMP(6) type?

From: <blabla120_at_gmx.net>
Date: 4 Apr 2006 06:50:21 -0700
Message-ID: <1144158621.520325.269150@g10g2000cwb.googlegroups.com>


Hi folks,

I have a table with a TIMESTAMP column:

create table ( myTime TIMESTAMP(6) );

I am a newbie to oracle and would like to know how I can convert a UTC timestring, which comes from an XML Schema datatype "xsd:datetime", e.g.

"02.04.2006T20:15:00"

to the TIMESTAMP format in oracle.

If this is not so easy it would be nice to know how to convert an oracle type DATETIME to the oracle type TIMESTAMP(6)

Thank you for any help,

Bernd Received on Tue Apr 04 2006 - 08:50:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US