Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
SQL TIME conversion
Name: sharitha Date: May 8, 2006 at 07:34:45 Pacific OS: UNIX CPU/Ram: 512 Product: HP
Comment:
Hi, I have an issue i need to display a date say (14-sep-2005 11:20:00) as 14-sep-2005 12:20:00) and (22-dec-2005 11:20:00) as (22-dec-2005 11:20:00). As of now my oracle SQL is showing these 2 as 11:20.I am not able to figure out the exact conversion to make this happen.Has this got anything to do with the time change.
Summary: hi, I need help on making a SQL query to find the total processing time of a document by each user by each day. The database is SQL server 2000. The original table is like: userid docid actiontime a...
Summary: Hi, I'm designin sort of asset manager software and i'm already stuck with some SQL-querys... :) Tables don't have all the fields yet, because it's just a test version. I have these tables: 1)PC (Cent...
Summary: OK i first want to apoligze for posting a message a couple of months ago about the same issue. It's just that i have no idea what i am doing but i want the experience. But at the same time i dont want...
