Member Avatar for nitin_4

i am trying to get data into oracle table from CSV file with SQL *LOADER but not getting the date which is in time zone format
I.E. 2013-02-23T10:41:14.000Z in my csv file.

i am using DATE as a type for Creation_Date.

pls help me to resolve this problem asap.

  • 3 Contributors
  • 6 Replies
  • 935 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by nitin_4
Member Avatar for nitin_4

please reply asap.

waiting fot ur prompt reply

Member Avatar for nitin_4

any help would be greatly appreciated

Member Avatar for hunar

SORRY NOT YET ...

Member Avatar for nitin_4

I am trying this format "'YYYY-MM-DDThh:mm:ss.ff[3]Z'" in my control file
but getting Error

"SQL*Loader-291: Invalid bind variable :mm in SQL string for column Creation_Date."

Member Avatar for urtrivedi

it is mi for minutes not mm

YYYY-MM-DDThh:mi:ss

Member Avatar for nitin_4

thnx for ur reply but it dint work ,
giving the same error " SQL*Loader-291: Invalid bind variable :mi in SQL string for column Creation_Date. "

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.