Search results for query: *

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

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

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

Can you give me more detail?

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

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;

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.

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

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]

that is correct.

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

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

You are correct it work just fine. Thanks.

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

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

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

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?

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

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:

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?