Hi All,
I have a issue with date format.
We are reading from seq file and loading in oracle db.
In source stage I am getting a date column as 'mm-dd-yyyy.hh.mm.ss' and it is having char data type in source side.
We are loding that in to date column (date (data type)) in oracle table.
Question is I have insert to table in format line 'dd/mm/yyyy'
I have used several fuction like string todate and all.
Is theere any way to do that . Please advise me.
I appriciate your time and patience.
Thanks
VKR
Date format writing to oracle
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Re: Date format
No, you don't. Unfortunately, if you think you do, that means you don't really understand DATE fields or how to work with them via SQL.aladap12 wrote:I have insert to table in format like 'dd/mm/yyyy'
What is your target stage? Is the SQL generated or user-defined? Those answers will help figure out what really needs (or should) happen.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Re: Date format
chulett wrote:No, you don't. Unfortunately, if you think you do, that means you don't really understand DATE fields or how to work with them via SQL.aladap12 wrote:I have insert to table in format like 'dd/mm/yyyy'
What is your target stage? Is the SQL generated or user-defined? Those answers will help figure out what really needs (or should) happen.
***********************************************************
target stage is oracle table, and it is genarated sql.
Thanks
Vkr
Target stage please, Oracle Enterprise? If so, set to what Write Method? What data type are you using in the job itself for this field - Date or Timestamp? Can you post the generated SQL?
The more details you provide up front, the sooner we can stop dancing and get you to a proper solution.
The more details you provide up front, the sooner we can stop dancing and get you to a proper solution.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers