quick convert date to string question

[graabein]

hi,

i've looked around the net for quite some time without finding the solution to this simple task... (i'm quite new to writing stored procedures and i haven't got any manuals), so please help me out:

i want to convert a datetime field to the following string: dd.mm.yy simple as that.

what's the fastest way of doing this?

cheers,
graabein

 

[GHolden]

I think this will do it...

CONVERT(VARCHAR(10),GETDATE(),104)

Replace GETDATE() with the date field



There are two ways to write error-free programs; only the third one works.