Post reply

Date

  • August 21, 2008 at 2:56 am

    #123181

    Hi Experts,

    How to take only date value from a datetime column?.

    And how to give convert three datas of one type and another two data of another type to a single type.

    For eg

    one type

    VAT4%

    VAT5%

    VAT6%

    Second type

    C.S.T

    C.B.I

    All this five data to value 1

    TIA

  • August 21, 2008 at 3:09 am

    #861091

    Hello,

    For the Date question, there are lots of built in date functions - See BOL "Date and Time Functions (Transact-SQL)", but I often use Convert e.g. Select @Date = Convert(Char(8), GetDate(), 112) - See BOL "CAST and CONVERT (Transact-SQL)".

    For the other question, I am not sure exactly what you want to do. If you want to cionditionally change data values to another specific value then you can use a Case statement - See BOL "CASE (Transact-SQL)".

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group

Viewing 2 posts - 1 through 1 (of 1 total)

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