Professional Web Applications Themes

System date without the time part - Microsoft SQL / MS SQL Server

Hi, How can I get the system's date without date and time part. Select GetDate() returns the time too but I would like to strip it. -- Thank you, Doru...

Sponsored Links
  1. #1

    Default System date without the time part

    Hi,

    How can I get the system's date without date and time part.

    Select GetDate()
    returns the time too but I would like to strip it.

    --

    Thank you,
    Doru


    Sponsored Links
    Doru Guest

  2. #2

    Default Re: System date without the time part

    You can use the CONVERT statement like this:
    SELECT CONVERT(VARCHAR(10), GETDATE(), 101)
    --
    HTH,
    SriSamp
    Please reply to the whole group only!
    http://www32.brinkster.com/srisamp

    "Doru Roman" <com> wrote in message
    news:phx.gbl... 


    SriSamp Guest

  3. #3

    Default Re: System date without the time part

    select Convert (Varchar(12), getdate(), 111)

    --
    HTH,
    Vinod Kumar
    MCSE, DBA, MCAD
    www.extremeexperts.com


    "Doru Roman" <com> wrote in message
    news:phx.gbl... 


    Vinodk Guest

  4. #4

    Default System date without the time part


    Hi Doru,

    The system date without the date and time is nothing!!

    The easiest way to get date only is to use the convert
    functions with an appropriate style. Check out the
    different styles on BooksOnLine - search for "Convert"

    Select
    CONVERT (varchar(10), GetDate(), 101 ) as '101',
    CONVERT (varchar(10), GetDate(), 102 ) as '102',
    CONVERT (varchar(10), GetDate(), 103 ) as '103'

    HTH,
    Eric 
    part. 
    Eric Guest

  5. #5

    Default Re: System date without the time part

    Thank you all

    Doru



    Doru Guest

Similar Threads

  1. system date/time
    By kstahl in forum Informix
    Replies: 11
    Last Post: January 25th, 04:23 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