Professional Web Applications Themes

get yesterday's date - Microsoft SQL / MS SQL Server

Hi! How can I get yesterday's date? or function that will get only the date yesterday in 'mm/dd/yyyy' format? joel...

Sponsored Links
  1. #1

    Default get yesterday's date

    Hi!

    How can I get yesterday's date? or function that will get only the date
    yesterday in 'mm/dd/yyyy' format?

    joel


    Sponsored Links
    Joel Gacosta Guest

  2. #2

    Default Re: get yesterday's date


    SELECT
    DATEADD(
    DD
    ,-1
    , CONVERT( CHAR(8) , CURRENT_TIMESTAMP , 112 )
    )

    "Joel Gacosta" <joelbluemediacomm.com> wrote in message news:udFkC33PDHA.3880tk2msftngp13.phx.gbl...
    Hi!

    How can I get yesterday's date? or function that will get only the date
    yesterday in 'mm/dd/yyyy' format?

    joel



    Damien Laffan Guest

  3. #3

    Default Re: get yesterday's date

    SELECT CONVERT(CHAR(10), (GETDATE()-1), 101)



    "Joel Gacosta" <joelbluemediacomm.com> wrote in message
    news:udFkC33PDHA.3880tk2msftngp13.phx.gbl...
    > Hi!
    >
    > How can I get yesterday's date? or function that will get only the date
    > yesterday in 'mm/dd/yyyy' format?
    >
    > joel
    >
    >

    Aaron Bertrand [MVP] Guest

  4. #4

    Default Re: get yesterday's date

    Actually, this gives yesterday's date in YYYYMMDD HH:MM:SS.mmm format...


    "Damien Laffan" <damien.laffanruralpress.com> wrote in message
    news:u1RLBN4PDHA.2160TK2MSFTNGP11.phx.gbl...

    SELECT
    DATEADD(
    DD
    ,-1
    , CONVERT( CHAR(8) , CURRENT_TIMESTAMP , 112 )
    )

    "Joel Gacosta" <joelbluemediacomm.com> wrote in message
    news:udFkC33PDHA.3880tk2msftngp13.phx.gbl...
    Hi!

    How can I get yesterday's date? or function that will get only the date
    yesterday in 'mm/dd/yyyy' format?

    joel




    Aaron Bertrand [MVP] Guest

  5. #5

    Default Re: get yesterday's date

    this should do...
    select convert(varchar,getdate()-1,101)

    --
    -oj
    RAC v2.2 & QALite!
    [url]http://www.rac4sql.net[/url]



    "Joel Gacosta" <joelbluemediacomm.com> wrote in message
    news:udFkC33PDHA.3880tk2msftngp13.phx.gbl...
    > Hi!
    >
    > How can I get yesterday's date? or function that will get only the date
    > yesterday in 'mm/dd/yyyy' format?
    >
    > joel
    >
    >

    oj Guest

  6. #6

    Default Re: get yesterday's date

    >> If you want to be pedantic,

    Actually, I was just pointing out that the format you offered was not the
    format the op asked for.

    But if you want to call that pedantic, great - have a good one.


    Aaron Bertrand [MVP] Guest

Similar Threads

  1. How to get the date of "Yesterday"
    By lxmanxl in forum Macromedia Flex General Discussion
    Replies: 2
    Last Post: October 19th, 01:49 AM
  2. Why Cox went down day before yesterday?
    By jef@eyeintegrated.com in forum PHP Development
    Replies: 0
    Last Post: August 14th, 03:05 PM
  3. can not do what i did yesterday
    By David L Cochran in forum Adobe Photoshop Elements
    Replies: 1
    Last Post: August 11th, 11:34 PM
  4. Easy way to get yesterday's date
    By Jeffrey Ross in forum AIX
    Replies: 5
    Last Post: July 28th, 11:45 AM

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