One Comment

  1. 8/9/2011

    Alternatively if the origin is a TIMESTAMP column and you need to shred the values via the columns section of XMLTABLE you can use

    DATUM TIMESTAMP(6) WITH TIME ZONE path ‘/date’

    This will result in something like “01-08-11 15:24:04,855000000″

Comments are closed.