Post reply

Dealing with Time

  • August 5, 2004 at 4:09 am

    #83523

    Hai Guys,

    How can i store only the time in a datetime field.

    Want to eliminate the default date.

    Thanks

  • August 5, 2004 at 6:10 am

    #517801

    store them in a char(5) field???

    MVDBA

  • August 6, 2004 at 5:06 am

    #517984

    Hi,

    try this :

    select right(getdate(),8)

    and stored it in a nvarchar(8).

    PS:You may need to convert it.

  • August 6, 2004 at 9:21 am

    #518030

    Use DB2 or other DBMS (Yukon) that supports TIME as a datatype. 

     

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply