Hi,
Is there a way in SQL to create a date/time variable in a
table and format the variable as "Short Date"? If yes,
can you tell me how? Thanks for your help.
Jen

Nope.

SQL Server stores DateTime datatypes in one format and one format only. To
do what you want you would have to format the output in the client. You can
use the CONVERT() function to output the DateTime attribute as a character
format.



--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Jen" <anonymous (AT) discussions (DOT) microsoft.com> wrote