Hi all,

Is it possible to open a connection to SQL Server and set the date
format once for the connection? I want to set the default date format
for all sql queries I'm running, instead of using CONVERT(varchar, date,
20)

Thanks,

Egbon

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

No, not for output. The available option SET DATEFORMAT does only determine how input is interpreted
for the numeric (separated) format.

--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver


"Egbon V." <vnjowusi (AT) gosps (DOT) com> wrote

Thanks.

Egbon

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!