Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bonzer2u

    Trying 2 Convert 0833 to time...Im Getting an Error

    Jeeez, 'abused' was quite the understatement, your step-through has really made an impression of how I will look at and (try to) create code in the future.
  2. bonzer2u

    Trying 2 Convert 0833 to time...Im Getting an Error

    Hi George, I thought my 'light' was starting to flicker abit, but its likely just a flashback. I see the structural similarities in code between this post and a recent question you answered for me as follows. Declare @Temp Char(4) Set @Temp = '1545' Select Right(Convert(VarChar(20)...
  3. bonzer2u

    CHAR to partial TIME conversion???

    Will do, Many thanks again George...
  4. bonzer2u

    CHAR to partial TIME conversion???

    George, Your code works perfectly and I sincerely appreciate your efforts. Nulls will be used for invalid times. I'm not worthy ... U.B.D.MAN
  5. bonzer2u

    CHAR to partial TIME conversion???

    Hi George, and many thanks, I do need the leading zero(s) if any AND the AM/PM suffix as this is a mainframe data source that I need to duplicate for a future SQL2000 datamart database. I tried your first method and got an error converting datetime from char string. Also note that my source...
  6. bonzer2u

    CHAR to partial TIME conversion???

    Greetings, I need to convert a char(4) source to time only datatype similar to what was discussed in this thread. http://www.tek-tips.com/viewthread.cfm?qid=1353645 Although I have tried various combinations of these and other suggestions in this forum, I cant seem to find a solution...

Part and Inventory Search

Back
Top