Re: change date format

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

  • Next message: Hugo Kornelis: "Re: change date format" 
    Date: Sat, 20 Nov 2004 21:57:21 -0000

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

    Here is what I have:

    right(RTrim(convert(char(8),TrnDate,12)),2) +
    substring(convert(char(8),TrnDate,12),3,2) +
    left(convert(char(8),TrnDate,12),2) as DteVal

    "Newbie" <noidea@nospam.com> wrote in message
    news:%23gfQUJ0zEHA.1192@tk2msftngp13.phx.gbl...
    > I have a table with a date field. I need to convert the date so that it
    > returns in a text format of DDMMYY - no separators.
    >
    > How do I do this?
    >
    >

  • Next message: Hugo Kornelis: "Re: change date format"