Hi All,
my DTS give me this date format when executed :
2003-11-02 00:00:00

is it possible to change it to 2.11.2003 ? i mean on DTS execution.

same question for numbers:
i have 200.23 and i want to change it to 200,23

Thank you very much

Yuval
[email protected]

Yuval Kronenfeld
Web Developer

__________________
Yuval Kronenfeld
Israel

Where is the dat coming from? If it is returned by a SELECT query for example you can use the CONVERT function to format it in any number of ways.

--

Joe

Hi again,

im using the following
SELECT CONVERT(smalldatetime, create_date, 4) AS test, *
FROM dbo.invoices

but i still get the date unformated (i tried several styles)

am i doing something wrong ?
it doesnt seem to have a formatting effect but it also doesnt throw an error