Professional Web Applications Themes

grab the time out of a smalldatetime - Microsoft SQL / MS SQL Server

Is it possible to grab 1:35 AM out of 8/9/2003 1:35:00 AM -- ______________________ David Fetrow HelixPoint LLC. http://www.helixpoint.com com Interested in Affordable Email Marketing? Check out the HelixMailer at http://www.helixpoint.com/helixmailer.asp If you are interested in becoming a Reseller of HelixPoint products, contact com ______________________...

  1. #1

    Default grab the time out of a smalldatetime

    Is it possible to grab 1:35 AM out of 8/9/2003 1:35:00 AM

    --

    ______________________
    David Fetrow
    HelixPoint LLC.
    http://www.helixpoint.com
    com

    Interested in Affordable Email Marketing?
    Check out the HelixMailer at http://www.helixpoint.com/helixmailer.asp
    If you are interested in becoming a Reseller of HelixPoint products, contact
    com
    ______________________


    Davef Guest

  2. #2

    Default Re: grab the time out of a smalldatetime

    "Davef" <com> wrote in message
    news:%phx.gbl... 

    Read up on
    DATEPART

    eg = cast(datepart(hh,log_date)as varchar) + ':' +
    cast(datepart(n,log_date) as varchar)



    mountain Guest

  3. #3

    Default Re: grab the time out of a smalldatetime

    Check out CONVERT in BooksOnLine.

    --

    Andrew J. Kelly
    SQL Server MVP


    "Davef" <com> wrote in message
    news:%phx.gbl... 
    contact 


    Andrew Guest

  4. #4

    Default Re: grab the time out of a smalldatetime

    Anyway to add AM or PM into that?

    "mountain man" <com.op> wrote in message
    news:xS5Za.24410$bigpond.net.au... 
    >
    > Read up on
    > DATEPART
    >
    > eg = cast(datepart(hh,log_date)as varchar) + ':' +
    > cast(datepart(n,log_date) as varchar)
    >
    >
    >[/ref]


    Davef Guest

  5. #5

    Default Re: grab the time out of a smalldatetime

    select substring(convert(varchar(20), getdate(), 22), 10, 5)
    + ' ' +
    right(convert(varchar(20), getdate(), 22), 2)





    "Davef" <com> wrote in message
    news:#phx.gbl... 
    contact 


    Aaron Guest

Similar Threads

  1. mx 6.1 selecting smalldatetime
    By drdave2 in forum Coldfusion Database Access
    Replies: 3
    Last Post: May 2nd, 01:11 PM
  2. MS SQL smalldatetime format
    By tccdover in forum Dreamweaver AppDev
    Replies: 2
    Last Post: August 12th, 09:00 PM
  3. <<Error converting data type char to smalldatetime>>
    By Gary D. Rezek in forum ASP Database
    Replies: 9
    Last Post: September 17th, 06:57 PM
  4. cast from datetime type to smalldatetime type?
    By Salim Afžar in forum ASP.NET General
    Replies: 2
    Last Post: August 1st, 03:29 PM
  5. cast from datetime type to smalldatetime type
    By Salim in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: July 29th, 01:48 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