1 Reply Latest reply: May 4, 2013 1:09 PM by joelkallman-Oracle RSS

    Timestump Format

    Kanaiya Sindhavad
      Which format i have to use to import folllowing date


      i tried 'RRRR-MM-DD"T"hh24:mi:ss'

      but it is not working

      With regards
        • 1. Re: Timestump Format
          Hi Kanaiya,

          1) Does your data really have two decimal points as the separator between seconds and fractional seconds? (you list an example of 2012-04-04T14:00:00..000000000).

          2) When you say "import data", how are you importing this? Through SQL Workshop -> Utilities -> Data Import? Or through Data Loading of an application?

          3) Define "it is not working".