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. FutureTech

    Work and family - Is a balance possible?

    Great discussion. It's nice to see that there are many others out there (male & female) who genuinely care about balancing family and career. I just got laid off on Friday (6/27). I think part of the reason is that I recently informed my manager that I could not commit to working unlimited late...
  2. FutureTech

    datetime manipulation in SQL

    Thanks for all the help. On Friday morning (6/27) I got laid off from my job. I didn't get to try all your suggestions, but I think I learned something from all of you anyway. Thanks, again.
  3. FutureTech

    datetime manipulation in SQL

    This is what I have in a datetime column: prod_end_dt 12/31/2002 12:00:00.000 AM 12/31/2049 12:00:00.000 AM 12/31/2002 12:00:00.000 AM 12/31/2002 12:00:00.000 AM This is what I want: prod_end_dt 12/31/2002 11:59:59.990 PM 12/31/2049 11:59:59.990 PM 12/31/2002 11:59:59.990 PM 12/31/2002...
  4. FutureTech

    datetime manipulation in SQL

    Still working on it. roccorocks, I need to update the entire time, not just the milleseconds. hneal98, I got an arithmetic overflow when trying the convert, so I'm trying to resolve that. My datetime column needs to remain a datetime column after the update. My latest attempt is to begin...
  5. FutureTech

    datetime manipulation in SQL

    I have records with datetime columns where the date portion is valid, but the time portion is incorrect. I want to correct the time portion for several records to read "11:59:59:990 PM" instead of the default "12:00:00:000 PM". How can I do this in an update statement?

Part and Inventory Search

Back
Top