Can I change the format in which Sql Server stores dates?

[Matrix.net]

Can I change the way that sql Server stores the dates for a single table's date column ?
the usual format is mm/dd/yyyy but I want it to store it like : yyyy/mm/dd . Is this possible ?

[Phil Weber]

SQL Server does not store dates in a particular format. Why do you ask?

[Matrix.net]

SQL Server does not store dates in a particular format. Why do you ask?

well its displaying the dates like : mm/dd/yyyy in the table, I want it to display the date as yyyy/mm/dd because the data has to be inserted to another table to create a csv file that has to have the date in that format because the csv file is going to get FTP'd and uploaded to an ORACLE db . (And no I cant just use dts because we cannot obtain permission to directly connect to the Oracle DB .

[Phil Weber]

If you're using .NET code to insert the data into the Oracle database, you may do something like this to format the date as desired:

' dr is a SqlDataReader
Dim DateValue As DateTime = dr.GetDateTime(ColNum)
Dim NewFormat As String = DateValue.ToString(Format)