Welcome to Sign in | Help
in Search
Home Blogs External Feeds Forums Photos Downloads About Us
» English Section » FAQ » T-SQL » Re: conversie datetime

conversie datetime

Last post 06-01-2007, 2:57 PM by rsocol. 2 replies.
Sort Posts: Previous Next

  •  06-01-2007, 11:52 AM 1999

    conversie datetime

    Reply Quote
    Salut

    pentru a lucra in mod unitar cu tipul de date datetime din sql server folosesc string-ul sub forma yyyymmdd spre exemplu tabel1.field5 > '20070601' care functioneaza.
    Cum pot sa ma folosesc si de ora? tabel1.field5 > '200706011730' nu functioneaza pentru a specifica 1 Iunie 2007 ora 17:30.

    Stie cineva?

    Mersi
    Calin

  •  06-01-2007, 2:55 PM 2000 in reply to 1999

    conversie datetime

    Reply Quote

    Uite un exemplu: 

    DECLARE @DataCuOra AS DATETIME
    SET @DataCuOra='20070101 17:30:00.000'
    SELECT @DataCuOra

    Rezultatul va fi:

    2007-01-01 17:30:00.000

    Katalyn

     

    Cătălin D.

  •  06-01-2007, 2:57 PM 2001 in reply to 1999

    Re: conversie datetime

    Reply Quote

    Vezi şi: http://www.karaszi.com/SQLServer/info_datetime.asp

    Răzvan 
View as RSS news feed in XML
Powered by Community Server (Commercial Edition), by Telligent Systems