Re: change date format
From: Newbie (noidea_at_nospam.com)
Date: 11/21/04
- Previous message: Hugo Kornelis: "Re: change date format"
- In reply to: Hugo Kornelis: "Re: change date format"
- Next in thread: Steve Kass: "Re: change date format"
- Reply: Steve Kass: "Re: change date format"
- Reply: Hugo Kornelis: "Re: change date format"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 21 Nov 2004 09:37:38 -0000
Thanks for the reply. I gave it a go but for the date 17/04/2000 it
returned
170420 instead of
170400
"Hugo Kornelis" <hugo@pe_NO_rFact.in_SPAM_fo> wrote in message
news:55ivp01419rdl6enh9v0lolt1cak6a5r14@4ax.com...
> 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)
- Previous message: Hugo Kornelis: "Re: change date format"
- In reply to: Hugo Kornelis: "Re: change date format"
- Next in thread: Steve Kass: "Re: change date format"
- Reply: Steve Kass: "Re: change date format"
- Reply: Hugo Kornelis: "Re: change date format"
- Messages sorted by: [ date ] [ thread ]