Data being truncated on insert, milllisecond.

1 message Options
Embed this post
Permalink
Chandler, Peter - 0443 - MITLL

Data being truncated on insert, milllisecond.

Reply Threaded More More options
Print post
Permalink
Some javascript/style in this post has been disabled (why?)

I am trying to do a WFS transaction/insert of date/time where I can pass-in (specify) the milliseconds  (SS.sss). The milliseconds are being truncated (see example below).

 

Any ideas how to get the Milliseconds into a datasource/database (SQL TIMESTAMP)?

 

Example:

 

Feature mapping XSD:

               <xsd:element minOccurs="0" name="startposition" type="xsd:dateTime">

                  <xsd:annotation>

                     <xsd:appinfo>

                        <deegreewfs:Content>

                           <deegreewfs:MappingField field="startposition" type="TIMESTAMP"/>

                        </deegreewfs:Content>

                     </xsd:appinfo>

                  </xsd:annotation>

               </xsd:element>

 

Input:

              <tfdm:startposition>2000-04-04T18:13:51.0123Z</tfdm:startposition>

 

Database Results (note “0123” lost):

               2000-04-04 18:13:51

 

Peter Chandler

MIT Lincoln Laboratory

244 Wood Street

Lexington, MA  02420

Email:  [hidden email]

781-981-3938

 


------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
deegree-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/deegree-users