Re: change date format

From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 11/20/04 

Date: Sat, 20 Nov 2004 23:44:47 +0100

On Sat, 20 Nov 2004 21:57:21 -0000, Newbie wrote:

>I have done it like as follows: Is there a better way of doing it?

Hi Newbie,

Have you tried
        REPLACE (CONVERT(char(8), TrnDate, 103), '/', '')

Best, Hugo 

-- 
(Remove _NO_ and _SPAM_ to get my e-mail address)