Can I change the format in which Sql Server stores dates?
the usual format is mm/dd/yyyy but I want it to store it like : yyyy/mm/dd . Is this possible ?
[195 byte] By [Matrix.net] at [2007-11-11 10:26:37] 
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 ?
# 1 Re: Can I change the format in which Sql Server stores dates?
SQL Server does not store dates in a particular format. Why do you ask?Phil Weber at 2007-11-11 23:43:17 >
# 2 Re: Can I change the format in which Sql Server stores dates?
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 .
Matrix.net at 2007-11-11 23:44:25 >
# 3 Re: Can I change the format in which Sql Server stores dates?
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)
Phil Weber at 2007-11-11 23:45:24 >
