Dears,
i have web site on my server and this server has oracle and the format date of my server is dd/MM/yyyy and also format date of my client is dd/MM/yyyy
but when he read the date give me this format M/d/yyyy
i need it read this format dd/MM/yyyy because i face problem in insert date
Thanks

http://download.oracle.com/docs/cd/B...htm#SQLRF00210

this format is used in procedure or functions but i'm using .net and i try this format M/d/yyyy and insert data the same keep in mind the server his format is dd/MM/yyyy
and i show this in regional and language option in windows control panel but why give me this format M/d/yyyy

This IS the database forum and you neglected to mention anything about .net so you got a solution for querying Oracle!

AND you simply use the date/time fuctions in the queries you send to the database server and the values return in the format you requested.

It is FAR more efficient to have database server handle the conversions than it is to handle the data in server side code!

the date of my server is as insert in the query but when request it from data based return to me in other format...i'm not format it he take windows format in insert data

Then you should convert it in your query. Either on INSERT/UPDATE or on SELECT.

USE the tools that are at your disposal in the DB server, rather than fighting against them in the server code!

i do that the same .