Informix Pass-Through Query
£10-20 GBP
Paiement à la livraison
Hello, I need some help with an informix pass through query.
Im currently connected to the database using access.
The query below needs modifiying
SELECT idc_userid as User , event_ts as hours, after_event_qty as Qty, event_loc1_text as Location, event_ts as Time, item_nbr as Item, substr(event_loc1_text,1,2) as Area
FROM wms_appl_event
WHERE ((event_type_desc)="PICK_OP") and ((event_ts) > today)
Event_ts as hours - Needs to display only the hour (currently [08/05/2018 08:11:48] needs to show [08]
I need a column for the Min from event_ts for each idc_userid within the time range
i need a column for the Max from event_ts for each idc_userid within the time range
i need a column called rate for the sum for the user divided by 1200
Where and ((event_ts) > today) needs to be (between today+07:00 and today+15:00)
Nº du projet : #16924112
À propos du projet
Décerné à:
I can help you with datetimes and dates informix data types , and aggregates. I will give you the sentence/s that you need. The best solution depends on your infomix database server version.
5 freelances font une offre moyenne de 23 £ pour ce travail
Hi, I have good proficiency in sql and worked on informix. Available to start now. please get in touch to discuss more. Regards, Manish
I have demonstrated experience on this site working with databases and SQL development and I think I have a solution for you that you can deploy pretty quickly if you award me your project. Message me with any extra in Plus
I am mohan choudhary, 3+ years experienced in websites and e-commerce development using HTML, HTML5, cSS, PHP/MySQL, Cake Php, laravel,Codeigniter, Anguler JS, Android,wordpress, IOS. * I Have best experience in lar Plus
Hello, I am proficient in Database and will help you with given query modification. Assure quality of work in quick turn around time. Thanks
