Re: formatting date field

bb_43_at_hotmail.com
Date: 04/30/04

  • Next message: Lahoty: "Re: formatting date field" 
    Date: Fri, 30 Apr 2004 23:56:31 GMT

    In article <ab57978db3accbc72020a324f2e8a984@news.teranews.com>, "Jarod_24" <jarod_24@hotmail.com> wrote:
    >How do i format a DateTime file in a sql-query?
    >
    >I got a sql sentence like this:
    >
    >"SELECT Name, DateRegistered
    > FROM Customer;"
    >
    >The "DateRegistered" field comes out as "2004-05-10T00:00:00.0000000+02:00"
    >I need it as "DD.MM.YYYY".
    >
    >Is there any function that i can use, like "DateFormat" in the sql sentence?
    >
    >Like This?
    >"SELECT Name, DateFormat(DateRegistered,"DD.MM.YYYY") As DateRegistered
    > FROM Customer;"
    >
    >
    Select Convert(varchar(10),Dateregistered,XXX)

    Where xxx is the appropriate value. See BOL on Convert for the table.

  • Next message: Lahoty: "Re: formatting date field"
    Loading