Professional Web Applications Themes

datetime values - Microsoft SQL / MS SQL Server

Hi, I need to display some datetime fields from a SQL 2000 database on my web page using aspx....The time value keeps showing up with the date. Unfortunately the code I am working with has not used SP's and has inline SQL. I am trying to avoid the time from displaying with the date without modifying each of the inline SQL statements. Is there an easier way to do this? Thanks!...

  1. #1

    Default datetime values

    Hi,

    I need to display some datetime fields from a SQL 2000
    database on my web page using aspx....The time value
    keeps showing up with the date.

    Unfortunately the code I am working with has not used
    SP's and has inline SQL. I am trying to avoid the time
    from displaying with the date without modifying each of
    the inline SQL statements.

    Is there an easier way to do this?

    Thanks!
    Jack Guest

  2. #2

    Default Re: datetime values

    Check out CONVERT function in SQL Server Books Online. There are various
    arguments you can use to display the DATETIME values to required format. For
    example :

    SELECT CONVERT(VARCHAR, CURRENT_TIMESTAMP, 101)

    --
    - Anith
    ( Please reply to newsgroups only )


    Anith Guest

  3. #3

    Default Re: datetime values

    > SP's and has inline SQL. I am trying to avoid the time 

    No, you will need to modify the statements (or use formatting functions
    available in .NET).


    Aaron Guest

Similar Threads

  1. Replies: 1
    Last Post: December 6th, 01:55 AM
  2. averaging the datetime values
    By SlowG in forum Informix
    Replies: 2
    Last Post: August 16th, 08:33 PM
  3. Formatting datetime values
    By Vishal Parkar in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 4th, 02:40 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