-
Hi all
I export / save my Ms access table to .csv file. For a date field it is storing data like 30-11-01 0:00:00.
In oracle loader control file I am using format as date “dd-mm-yy hh:mm:ss” . result of this command it is not loading any record into my table pls help me
Regards
babjee
-
Hi,
Try to give like this:
field1 DATE 'dd-mon-yy'
HTH.
Thanks.
Vijay.
Say No To Plastics
-
Try dd-mm-yy hh:mi:ss
instead of
dd-mm-yy hh:mm:ss
-
Originally posted by babjee
Hi all
“dd-mm-yy hh:mm:ss” .
Regards
babjee
This is really the most commonly made mistake.The correct is....
[B] dd-mm-yy hh:mi:ss [B]
Then u won't forget it, I hope.
Cheers!!
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
-
Originally posted by babjee
Hi all
“dd-mm-yy hh:mm:ss” .
Regards
babjee
This is really the most commonly made mistake.The correct is....
dd-mm-yy hh:mi:ss
Then u won't forget it, I hope.
Cheers!!
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
-
Looks like Tarry's got poor eyesight !!
I posted the correct format without the bells and whistles, and only the once !! And without the patronising font
-
I like bell's and whistles!
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
-
HI ALL
HI ALL
It d'nt works. I user this format "dd-mm-yy hh24:mi:ss"
it is working fine. thank u for ur sugessions
regards
babjee
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|