Professional Web Applications Themes

DateDiff and Format - Microsoft SQL / MS SQL Server

Hello, I've included a datediff function in my stored procedure, and it works correctly, but I want to format it to return only the Month and the Date. I know the Format Function does not work in an SP is there any function that I can use to quickly format the returned value? Thank you,...

  1. #1

    Default DateDiff and Format

    Hello,

    I've included a datediff function in my stored procedure,
    and it works correctly, but I want to format it to return
    only the Month and the Date. I know the Format Function
    does not work in an SP is there any function that I can
    use to quickly format the returned value?

    Thank you,
    Brandon Guest

  2. #2

    Default Re: DateDiff and Format

    There is no 'format' function in t-SQL. Instead you can use CONVERT,
    DATEPART etc. for your requirement.

    SELECT RIGHT(CONVERT(VARCHAR, CURRENT_TIMESTAMP, 103), 7)
    SELECT CAST(MONTH(GETDATE()) AS VARCHAR) + '-' +
    CAST(YEAR(GETDATE()) AS VARCHAR)
    SELECT CAST(DATEPART(m, CURRENT_TIMESTAMP) AS VARCHAR)+ '/' +
    CAST(DATEPART(yy, CURRENT_TIMESTAMP) AS VARCHAR)

    See more details about CONVERT & other date functions in SQL Server Books
    Online.

    --
    - Anith
    ( Please reply to newsgroups only )


    Anith Sen Guest

Similar Threads

  1. Datediff() bug
    By OldCFer in forum Macromedia ColdFusion
    Replies: 21
    Last Post: November 24th, 09:35 AM
  2. dateDiff Question
    By Winston2 in forum Coldfusion - Getting Started
    Replies: 2
    Last Post: November 2nd, 02:30 PM
  3. Datediff Problem
    By Tim::. in forum ASP Database
    Replies: 6
    Last Post: October 9th, 07:49 PM
  4. Datediff
    By Alexander Hoffmann in forum PHP Development
    Replies: 1
    Last Post: December 11th, 08:34 PM
  5. DateDiff in C#
    By Mark Fox in forum ASP.NET General
    Replies: 3
    Last Post: July 16th, 01:26 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139