Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Date format linux client side

Seek78Aug 12 2009 — edited Aug 13 2009
Hi people,
I need to set the date format in "MMDDYYYY" (yes, we are in Europe :-) ), on a linux client, in order to are able to perform sql like this: insert into mytable(myfield) values('12092009').
There is a way to do that only on a single client, without using an alter session statement?

The scope is to port an old console application, and I'm using an 11 client with an 11g server.

Thanks all
Claudio
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 10 2009
Added on Aug 12 2009
#11g, #general-database-discussions, #sql
8 comments
1,231 views