Default Date Format

Hello All
In oracle we can specify the default date format for the datebase
connection, is there a way to specify the default date format and language
for SQL Server database connections. I am using DB-Library for C to
communicate to SQL Server from MS Visual C++.
Hope to get reply soon
Thanks
FaisalSET DATEFORMAT should work
regards,
Harshal.
"Faisal Mansoor" <fmansoor@.softpak.com> wrote in message
news:ukd6ezqLFHA.1180@.TK2MSFTNGP14.phx.gbl...
> Hello All
> In oracle we can specify the default date format for the datebase
> connection, is there a way to specify the default date format and language
> for SQL Server database connections. I am using DB-Library for C to
> communicate to SQL Server from MS Visual C++.
> Hope to get reply soon
> Thanks
> Faisal
>|||Only for input, not for output. Default date format for input is inherited f
rom the login, but can
be overridden by SET DATEFORMAT. I suggest you read
http://www.karaszi.com/SQLServer/info_datetime.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Faisal Mansoor" <fmansoor@.softpak.com> wrote in message
news:ukd6ezqLFHA.1180@.TK2MSFTNGP14.phx.gbl...
> Hello All
> In oracle we can specify the default date format for the datebase
> connection, is there a way to specify the default date format and language
> for SQL Server database connections. I am using DB-Library for C to
> communicate to SQL Server from MS Visual C++.
> Hope to get reply soon
> Thanks
> Faisal
>