Post reply

date

  • March 3, 2006 at 9:01 am

    #93431

    I am using datetime data type for a field which displays the result with date and time but I want to display only date without time, what function i need to use to convert that.

  • March 3, 2006 at 9:45 am

    #624655

    Here's one suggestion:

    convert

    (datetime, convert(char(10), Put_Date_Here, 103), 103)

  • March 3, 2006 at 9:55 am

    #624659

    DATEADD(DD, 0, DATEDIFF(DD, 0, DateTimeValue))

     

  • March 3, 2006 at 10:14 am

    #624668

    True. This is the version to choose! For it is format independent, compared to several weird "CONVERTS".


    _/_/_/ paramind _/_/_/

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

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