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 Chriss Miller 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. EM1107

    calculated time difference.

    Good day everyone. I am not an expert in MS Access and just started using it. I have figured how to calculate time difference but as it is it only appear on my table while I add the time start and time stop. My next step is to store this data into a column so that I can see the the value when I...
  2. EM1107

    populate a column with time from other column.

    Good day I am new to MS Access and I need to create a table where the value that should be inserted in the column is the time calculation of two other columns. So I have a table with 3 columns. Start_time, Stop_time, TIME_SPENT When I insert my start time and stop time I want the Time_SPENT...
  3. EM1107

    Copy folder and content using SQL Server TSQL.

    Good day Guys I hope someone can help me on that one. I am trying to copy documents that has the folder structure and document name stored in tables and the actual document is store on a document server. I take the path and files name using TSQL and copy the files to a new location including...
  4. EM1107

    How to convert CLOB data into number and compare it to other table.

    Can you give me more detail?
  5. EM1107

    How to convert CLOB data into number and compare it to other table.

    ...AS NUMBER(10)) AS DOCNUMBER FROM MYTABLE WHERE NAME = 'LINKID') Error report - ORA-01722: invalid number 01722. 00000 - "invalid number" *Cause: The specified number was invalid. *Action: Specify a valid number. Would anyone have an idea as to how I could do that? If I could simply...
  6. EM1107

    Converting data from rows to column.

    I have no problem with that. SELECT DESCRIPTION, ORDERNUMBER, TYPE, LINKID as DOCNUMBER, LINKNAME as DOCUMENT_NAME, LIBRARY FROM ( SELECT ENTITYID, NAME, DATA FROM DOCSADM.REGISTRY ) REGISTRY_RESULT PIVOT ( MAX(DATA) FOR NAME IN (DESCRIPTION, ORDERNUMBER, TYPE, LINKID, LINKNAME, LIBRARY) ) PIV;
  7. EM1107

    Converting data from rows to column.

    Thanks guys I made some changes to the script and it now work properly. I simply specified the table I wanted instead of doing the Select * and it now work properly. Thanks for all your suggestions. This was greatly appreciated.
  8. EM1107

    Converting data from rows to column.

    I tried the following but it return an error because the DATA column is a varchar(max) value. Any Idea? SELECT * FROM ( SELECT [entityid], [name], [data] FROM docsadm.registry ) tableResults PIVOT ( SUM([data]) FOR Name IN...
  9. EM1107

    Converting data from rows to column.

    dhookom where is the beginning of the code? I only see a part of the code. WITH cteFixNames AS (SELECT [EntityID] ,[Name] as TheName ,[Data] FROM [dbo].[tblEM1107]
  10. EM1107

    Converting data from rows to column.

    that is correct.
  11. EM1107

    Converting data from rows to column.

    That is correct. I guess it got mixed after a saved the informaiton.
  12. EM1107

    Converting data from rows to column.

    Good day everyone I hope someone can help me here. I have to convert some data information from column to rows but I am not sure how i should do this. Bellow you will see an example of what I want to do. The data in my table appear as follow first row being the columns of course. ENTITYID...
  13. EM1107

    Insert date and time using UTC time in a DATE column

    You are correct it work just fine. Thanks.
  14. EM1107

    Insert date and time using UTC time in a DATE column

    Actually! I did not try it that way so it might be just as good. I will give it a try.
  15. EM1107

    Insert date and time using UTC time in a DATE column

    Thanks for you help guys but I found what I was looking for. I can use the following select sys_EXTRACT_UTC(systimestamp) from dual; This is returning the UTC DATE from the system date. I can just place this into a variable and insert it in my table. I just created a variable as follow...
  16. EM1107

    Insert date and time using UTC time in a DATE column

    If I wanted to only modify the time a on time that would be what I would do. But If I want to add this as part of a trigger for instance, I do not want to have to modify the trigger twice a year just to be sure it insert the information with the correct Date and Time. Same goes if I have an...
  17. EM1107

    Insert date and time using UTC time in a DATE column

    Cool that resolved the issue for SQL Developer not showing the proper date and Time. How bout getting my date inserted in UTC time? For the moment if I insert the date time it will be current date time not UTC. How do I convert the time to UTC?
  18. EM1107

    Insert date and time using UTC time in a DATE column

    Andy if I run the command select SYSDATE from DUAL I only get the date no TIME. I only get DD-MM-YYYY.
  19. EM1107

    Insert date and time using UTC time in a DATE column

    If I run your command Andy I get the following error. ORA-01821: date format not recognized 01821. 00000 - "date format not recognized" *Cause: *Action:
  20. EM1107

    Insert date and time using UTC time in a DATE column

    The filed is just a date data type field and if I do an insert into the date field and select the SYSDATE it only appear as a date no time with it when I do a select. If the SYSDATE does insert the date and time how can I convert the time provided by the SYSDATE into a UTC DATE?

Part and Inventory Search

Back
Top