Professional Web Applications Themes

Problem converting Date to dd/mm/yyyy - Microsoft SQL / MS SQL Server

Hi, In SQL how to convert 1/7/2003 8:55:00 AM to 1/7/2003? SF...

  1. #1

    Default Problem converting Date to dd/mm/yyyy

    Hi,

    In SQL how to convert 1/7/2003 8:55:00 AM to 1/7/2003?

    SF


    SF Guest

  2. #2

    Default Problem converting Date to dd/mm/yyyy

    SELECT CONVERT(varchar(12), getdate() , 112)

    Rajesh Peddireddy
     
    Rajesh Guest

  3. #3

    Default Re: Problem converting Date to dd/mm/yyyy

    Is that supposed to be July 1st or January 7th?

    For input purposes, always use YYYYMMDD... then you can be sure that the
    output is accurate.

    DECLARE foo DATETIME
    SET foo = '20030701'
    SELECT CONVERT(CHAR(10), foo, 103)

    For more info on dd/mm/yyyy and other formats, see

    http://www.aspfaq.com/2460
    http://www.aspfaq.com/2260
    http://www.aspfaq.com/2464





    "SF" <com.kh> wrote in message
    news:phx.gbl... 


    Aaron Guest

Similar Threads

  1. Converting MM/DD/YYYY to Date/Time Object
    By Adam? in forum Macromedia ColdFusion
    Replies: 2
    Last Post: August 30th, 03:27 AM
  2. YYYY-MM-DD date format issue
    By DOUGLAS HEESTAND in forum FileMaker
    Replies: 2
    Last Post: November 5th, 04:22 AM
  3. Replies: 3
    Last Post: August 31st, 09:45 PM
  4. converting date into database date format(newbie)
    By Binay Agarwal in forum PHP Development
    Replies: 2
    Last Post: August 29th, 01:09 PM
  5. Converting Date
    By bigforehand in forum Macromedia Dynamic HTML
    Replies: 2
    Last Post: July 15th, 04:18 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