Post reply

DateTime time format issues

  • November 26, 2008 at 3:04 pm

    #196647

    Hi,

    I am pulling in the date and time of a request from another program and storing this information in a column called request_date. However, when the information is entered into SQL, the date is entered correctly but the time always defaults to 12:00:00 AM. How do I fix this so that the time shows the actual time of the request?

    Thanks!

  • November 26, 2008 at 6:38 pm

    #904102

    The presentation of your question is rather vague, for example

    storing this information in a column called request_date.

    . Is this

    column

    an element of a SQL table, or should it be as a parameter or program variable or ? ? ?. If you supply some sample data, the structure of the SQL table you are attempting to insert this data into and some sample data some one would most likely be willing to assist you.

    Read the article in my signature block to learn how to present a problem in the best way to quickly obtain assistance, then edit your post to provide the data.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • November 26, 2008 at 7:21 pm

    #904106

    Show us the code that you are using to enter the datetime.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply