Re: change date format

From: Newbie (noidea_at_nospam.com)
Date: 11/21/04

  • Next message: Steve Kass: "Re: change date format" 
    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)

  • Next message: Steve Kass: "Re: change date format"