Professional Web Applications Themes

retrieving the DAY from the datetime value i.e. "monday", "tuesday" .... - Microsoft SQL / MS SQL Server

Dear sir, How do you retrieve the day of the week from the datetime value? I don't want the number. But I want like, 'Monday', 'Tuesday' and so on. Is it possible? zeallous...

  1. #1

    Default retrieving the DAY from the datetime value i.e. "monday", "tuesday" ....

    Dear sir,

    How do you retrieve the day of the week from the datetime value? I
    don't want the number. But I want like, 'Monday', 'Tuesday' and so on.
    Is it possible?

    zeallous
    anson Guest

  2. #2

    Default Re: retrieving the DAY from the datetime value i.e. "monday", "tuesday" ....

    Check out DATENAME in BooksOnLine.


    --

    Andrew J. Kelly
    SQL Server MVP


    "anson" <aeze616cse.unsw.edu.au> wrote in message
    news:cb7ba330.0306301619.3e082412posting.google.c om...
    > Dear sir,
    >
    > How do you retrieve the day of the week from the datetime value? I
    > don't want the number. But I want like, 'Monday', 'Tuesday' and so on.
    > Is it possible?
    >
    > zeallous

    Andrew J. Kelly Guest

  3. #3

    Default Re: retrieving the DAY from the datetime value i.e. "monday", "tuesday" ....

    SELECT DATENAME(dw, GETDATE())

    --
    Aaron Bertrand, SQL Server MVP
    [url]http://www.aspfaq.com/[/url]

    Please reply in the newsgroups, but if you absolutely
    must reply via e-mail, please take out the TRASH.


    "anson" <aeze616cse.unsw.edu.au> wrote in message
    news:cb7ba330.0306301619.3e082412posting.google.c om...
    > Dear sir,
    >
    > How do you retrieve the day of the week from the datetime value? I
    > don't want the number. But I want like, 'Monday', 'Tuesday' and so on.
    > Is it possible?
    >
    > zeallous

    Aaron Bertrand [MVP] Guest

Similar Threads

  1. Replies: 1
    Last Post: April 24th, 01:27 PM
  2. CFINPUT type="radio" w/ "value" requires "label"
    By Iceborer in forum Macromedia ColdFusion
    Replies: 2
    Last Post: February 21st, 06:16 PM
  3. #26162 [NEW]: $a="0abcdefg";if ($a==0) echo "OK"; result is "OK" ?!
    By zhuminglun at yahoo dot com dot cn in forum PHP Development
    Replies: 0
    Last Post: November 7th, 12:04 PM
  4. dr("field").toString returns "400.0000" instead of "400"
    By Dan C Douglas in forum ASP.NET General
    Replies: 5
    Last Post: July 22nd, 05:48 PM
  5. "Start" "Program" "Menu" list is empty
    By Pete in forum Windows XP/2000/ME
    Replies: 2
    Last Post: July 10th, 10:42 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