Hi All,
Could you please look into this
" How to convert julian Date format to Oracle Date format "
Thanks in Advance
srini
How to convert julian Date format to Oracle Date format
Moderators: chulett, rschirm, roy
![Exclamation :!:](./images/smilies/icon_exclaim.gif)
That being said - there's no such thing as "Oracle date format". Oracle dates are stored in an internal representation and you can load and extract them from Oracle in pretty much any format.
What's important when loading is to make sure the format of the date and the format mask you are using match. And the best way to do (IMHO) that is to stick with ISO formatting, which is what the stages will automatically generate and consume.
My 'rules' are to stick with the Timestamp datatype when dealing with Oracle DATE fields. The OCI stages automatically generate SQL to extract or load the fields in the following format:
Code: Select all
YYYY-MM-DD HH24:MI:SS
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Re: How to convert julian Date format to Oracle Date format
The specific answer depends on whether this is in fact a Julian date or an Ordinal date. That will drive the flavor of IConv you will use to convert the date to internal format.ysrini9 wrote:How to convert julian Date format to Oracle Date format
After that, my advise for the output format applies.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 232
- Joined: Fri Sep 30, 2005 4:52 am
- Contact: