This discussion is archived
1 Reply Latest reply: May 4, 2013 11:09 AM by jkallman RSS

Timestump Format

KanaiyaSindhavad Newbie
Currently Being Moderated
Hi
Which format i have to use to import folllowing date

2012-04-04T14:00:00..000000000

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

but it is not working

With regards
  • 1. Re: Timestump Format
    jkallman Employee ACE
    Currently Being Moderated
    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".

    Joel

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points